Link to home
Create AccountLog in
Avatar of luyan
luyan

asked on

Why "Automatic" start SQL Server Agent didn't work?

I set up startup type to "Automatic". So it means when the SQL Server is stopped and then started, SQL Server Agent will follow to start. Am I right?  
I just tried to stop SQL Server and restart it. Wait for a while, but I didn't see the SQL Server Agent get start by itself. Why?
Thanks!
ASKER CERTIFIED SOLUTION
Avatar of rlsm_tech
rlsm_tech
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
The file path for the SQL Agent/Manger on a default install is:

"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe" /n

And a shortcut to the startup is typically placed in the windows startup folder.

RLSM Tech
SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.