david7777777777
Programmer
Is the SQLSERVERAGENT service set to start manually by default when you install SQL 2000 or above? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQLSERVERAGENT startup default
- Thread starter david7777777777
- Start date
- Status
No it is NOT. In fact, when you stop and restart the SQL Server service through a Server Reboot, the SQL Server Service Manager or maybe an NET START/NET STOP command, the SQL Server Agent service WILL NOT autmatically restart by default. You can apply a fix to that which entails creating a stored procedure in the Master DB and then setting it to AutoStart whenever the SQL Server service starts up. To do this, follow the steps I have listed out in this thread ...
thread962-868950
Thanks
J. Kusch
thread962-868950
Thanks
J. Kusch
- Status
Similar threads
- Locked
- Question
- Locked
- Question