Autostart SQL Server Agent

[thibault]

I'm running a desktop version of SQL 7 that came with the study guide I purchased. I want to make SQL Server Agent start automatically when I start the SQL Server Service. I can't find any instructions on how to do it, or figure out how to do it myself. I'm growing a little tired of starting it manually every time i want to use it. What am I missing?
tia,
t

bobbie
thibault@hotbot.com

http://pages.hotbot.com/edu/thibault

 

[Bernadette]

Hi There

To start the SQLAgent with the OS
-----------------------------------
1. On the server open up the "Service Manager". You will
find this in the SQLServer Program Group or by clicking
on the icon in the system tray.

2. Select "SQLServiceAgent" from the services combo box

3. Check the "Auto start service when OS starts" check box
This will start the Sql Agent Service with the
MSSQLServer service when the Operating System starts.

To re-start the Services automaticaly if they stop
---------------------------------------------------

1. Open Enterprise Manager
2. Click on "Management"
3. Right-Click on "SQL Server Agent"
4. Select "Properties" from the pop-up menu
5. Click the "Advanced Tab"
6. Ensure that the "Auto start SQL Server" and "Auto start
SQL Agent" checkboxes are checked.


Good Luck
Bernadette