SQL Server DTS package will not allow for scheduling since SQLServerAgent is stopped - how to turn on?
I'm trying to schedule several DTS packages by right-clicking over DTS and selecting Schedule Package - when I do so I get the following warning: The SQLServerAgent on target server LOCAL is stopped. Make sure it is running during the scheduled execution of this package. How do I make sure that the SQLServerAgent is started and running - including if the machine is restarte?
ASKER
And if I don't see SQLServerAgent - in under Administrative Tools?
ASKER
I see it under Services (under Administrative Tools) but when I try to start it - it says:
Could not start the SQLSERVERAGENT service on Local Computer.
The service did not return an error. This could be an Internal windows error or an internal service error.
If the problem persists, contact your system administrator.
Could not start the SQLSERVERAGENT service on Local Computer.
The service did not return an error. This could be an Internal windows error or an internal service error.
If the problem persists, contact your system administrator.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you greatly - the log explained why - the user was not added to the list.
Set its startup to Automatic.
You can check and see if it is tarted there as well.
Or look in Enterprise Manager to see if the green arrow next to SQL Server Agent under Management in the SQL Server tree is bright green.