Top "Sql-server-agent" questions

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs.

sp_start_job wait for job to finish

Possible Duplicate: Executing SQL Server Agent Job from a stored procedure and returning job result Is there a way to …

sql-server sql-server-agent
Get date of last successful job run?

I have a single step job that executes a stored procedure. I would like get the date of the last …

sql-server sql-server-agent
Executing the same SSIS Package with different parameters at different time

I have a SSIS package running at 8 PM in the evening for the Year 2011. I would like to run the …

sql-server-2008 parameters ssis sql-server-agent
The Messenger service has not been started - NetSend notifications will not be sent

In my SQL Server agent, I did not set any notifications, then why this error is coming? I run pakg …

sql-server sql-server-2008-r2 sql-server-agent
SSIS package not running when called as step in SQL Job

I have a .dtsx file (an SSIS package) that downloads files from an FTP server and imports data. It runs …

ssis permissions sql-server-agent
Enable/Disable Sql Server Agent using a t-sql script

Is it possible to enable or disable the sql server agent using t-sql?

sql-server sql-server-agent
"The specified '@notify_email_operator_name' is invalid" error

I have a scripted SQL Server Agent job I'm trying to transfer over to my local database from a server, …

sql-server sql-server-2008 sql-server-agent
How to set up SQL server Agent? not showing in Sql Server Management

I am trying to set up the SQL Server Agent on our test server running with windows Small Business Server 2011 …

sql sql-server sql-server-2008 ssms sql-server-agent
SQL 2008 SQL Server Agents Jobs, how to populate email for Notifications

I am trying to add my email address to notifications for SQL Server Agent Job when it fails.. So I …

sql-server sql-server-agent
Will a SQL Server Job skip a scheduled run if it is already running?

If you schedule a SQL Server job to run every X number of minutes, and it does not finish the …

sql sql-server scheduled-tasks sql-server-agent