Enabling SQL server Agent - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Enabling SQL server Agent

Author

Topic

satya068
Posting Yak Master

233 Posts

Posted - 2010-03-19 : 12:06:55

Hi..
I need to enable the SQL server agent and see it should run.
could anyone know how to do this?

thanks

yashu

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-19 : 16:01:44

You stop/start it in the Services applet in Control Panel/Admin Tools. Set it to automatic instead of manual so that it starts up on its own after a restart of the server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

satya068
Posting Yak Master

233 Posts

Posted - 2010-03-23 : 05:45:29

Thanks its worked

quote:
Originally posted by tkizer

You stop/start it in the Services applet in Control Panel/Admin Tools. Set it to automatic instead of manual so that it starts up on its own after a restart of the server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

yashu

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-23 : 12:29:14

You're welcome.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources