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 06, 2009 12:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, March 06, 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 06, 2009 12:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:37 AM
Points: 2,403, Visits: 1,863
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 06, 2009 2:17 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, February 10, 2014 7:18 AM
Points: 789, Visits: 1,193
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 06, 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 01, 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