May 7, 2003 at 9:12 am
Running sql2k with latest service pack. I want to begin using sql server agent to do some of the daily things. I have setup a job on enterprise manager, but when I try to execute it, I get 'sqlserver agent is not currently running so it cannot be notified of this action'. Ok..so I go to start the sql server agent running and get this 'specified service does not exist as an installed service....'. PLEASE how do I get the sql server agent up and running so I can automate this stuff?
May 7, 2003 at 9:15 am
Right click on My Computer, select Manage, select Services. Or, open Control Panel and click on Services. Do you see SQLSERVERAGENT in the list of services?
May 7, 2003 at 9:24 am
In Enterprise Manager, Expand the Management folder, then right click SQL Agent and select start. Should start. If not, post back with the error (check SQL log and Event logs)
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 7, 2003 at 9:25 am
sqlserveragent is NOT in the list of installed services. I had not touched the product before they gave it to me to install. Its ENTIRELY possible something wasn't done right on the setup.
May 7, 2003 at 9:30 am
Get to the server manager and check on autostartup options. sqlAgent might not have been started. start it and check box for autostartup.
May 7, 2003 at 9:32 am
Steve...server agent will not start up. See message in initial post when trying to start up. I think gfahrlander is on the right track here.
May 7, 2003 at 9:38 am
Reinstall - That's all... whoever set it up must have excluded SQL Server Agent. You've got to have it!
May 7, 2003 at 9:41 am
I have the cd and can do the install again..but seeing as to how this is my production server..you can understand my concern as to messing up whats already there. Is there any way to install this on another computer..and copy the sqlserver agent part to this server?
May 7, 2003 at 9:46 am
Oh boy, it's never easy is it? Backup all system and user databases (except tempdb), schedule your prod server downtime and reinstall and restore all (some will have to be in single user mode).
Good Luck 🙂
May 7, 2003 at 11:21 am
I went digging..found sqlagent.exe WAS installed on the server. I ran another program that set it up as a service..started the service...now I'm in business! Having the program running as a service was the missing part.
May 12, 2003 at 3:20 pm
What program is this that allowed you to install sqlagent.exe as a service?
May 13, 2003 at 11:45 pm
Found a program to install any program as a service..and do it remotely. Drop me at line at ledetb@touro.com and I'll email it to you.
May 19, 2003 at 8:23 am
I did a net search while back..found a utility svrinstw.exe. You copy the program to the server, then run this to install it in the service portion of windows.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply