Export (0) Print
Expand All

Starting, Stopping, and Pausing SQL Server Agent Service

Microsoft SQL Server Agent must be running as a service in order to automate administrative tasks. You can configure the SQL Server Agent service to start automatically when the operating system starts, or you can start it manually when you need to complete jobs. You can stop or pause the SQL Server Agent service to suspend jobs, operator notifications, and alerts.

ms190695.note(en-US,SQL.90).gifNote:
By default, the SQL Server Agent service is disabled when Microsoft SQL Server 2005 is installed unless the user explicitly chooses to autostart the service.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft