SQL Server Agent not running

sql-server-2008 sql-server-agent sql-job
Curt picture Curt · Jul 14, 2011 · Viewed 21.9k times · Source

None of the SQL Jobs on my server are running. I've looked into this and got the message:

SQLServerAgent is not currently running so it cannot be notified of this action

How can I get SQL Server Agent to start running on SQL Server 2008?

Answer

oryol picture oryol · Jul 14, 2011

net start SQLSERVERAGENT (for default instance, or just use services.msc or SQL Server Configuration Manager)

Related questions

How do I execute a stored procedure in a SQL Agent job?

I am using SQL Server 2008 and I need to run a SQL Job from SQL Server Agent. I am new to SQL Server Job and I want to execute a stored procedure regularly from a SQL Server Job. But I …

Read More
SQL Server Agent Job Notify multiple operators on failure

I have a Job setup in SQL Server 2008 which sends a notification email to one operator when the job fails. Question: Is it possible to setup a notification email being sent to multiple operators for that specific job? I believe …

Read More
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 same package at 8:30 PM for the Year 2010. I made a SSIS Package configuration file and accept the "Year" as a …

Read More