Menu
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?
783
Microsoft SQL Server Agent must be running as a service in order to automate administrative tasks. For more information, see Configure SQL Server Agent. Object Explorer only displays the SQL Server Agent node if you have permission to use it.
To view job activity In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance. Expand SQL Server Agent. Right-click Job Activity Monitor and click View Job Activity. In the Job Activity Monitor, you can view details about each job that is defined for this server.
Similar to Windows services, SQL Agent Jobs run under a user or service account configured in the job. Job failures can occur when there are permission or authentication issues with the user or service account. Common issues include: Account expired.
net start SQLSERVERAGENT (for default instance, or just use services.msc or SQL Server Configuration Manager)
148
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
