Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Agent Stops On Server Restarts Expand / Collapse
Author
Message
Posted Wednesday, May 6, 2009 12:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, March 6, 2013 11:48 PM
Points: 66, Visits: 160
Hi,
My SQL Agent STOPS every time my Server Restarts,
is there anything that SQL Agent should start automaticlly

Thanks

Parth
Post #710836
Posted Wednesday, May 6, 2009 12:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
set sql server Agent service startup type to Automatic.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #710841
Posted Wednesday, May 6, 2009 2:17 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 1:59 AM
Points: 804, Visits: 1,195
Go to Start, Programs, Microsoft SQL Server 2005, Configuration Tools, SQL Server Configuration Manager and select SQL Server 2005 Services. Right click over SQL Agent and select Properties. On the Service tab click on Start Mode - you'll then be able to use the drop down menu to select Automatic startup. You'll need to make sure that the account running the Agent Service has Log on as Service rights too.

Cath




Regards,
Cath

"Hang on lads, I've got a great idea. "
Michael Caine (Charlie Croker) The Italian Job
Post #710870
Posted Wednesday, May 6, 2009 5:22 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, June 1, 2009 6:06 AM
Points: 518, Visits: 354
You can set the sql agent startup to automatic mode.This option is available in windows services

+++BLADE+++
Post #710942
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse