JOBs aren't running - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

JOBs aren't running

Author

Topic

SamC
White Water Yakist

3467 Posts

Posted - 2004-10-18 : 10:36:37

None of my SQL Jobs have run since last Thursday. No errors, the schedules look good. They're all enabled.

What's up with that?

Sam

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2004-10-18 : 11:06:20

Is the SQL agent running?

Corey

SamC
White Water Yakist

3467 Posts

Posted - 2004-10-18 : 11:26:58

Apparently SQL Agent doesn't restart automagically after restarting SQL server.

Where's the picture? Your vacation?

X002548
Not Just a Number

15586 Posts

Posted - 2004-10-18 : 11:36:54

Sam,

You need to make sure that it does start when the server reboots.

And to check out Corey's "stuff", do a reply and check out the link...

Brett

8-)

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2004-10-18 : 14:37:59

actually all you have to do is click the photo... i made it a link as well

Corey

Kristen
Test

22859 Posts

Posted - 2004-10-18 : 14:39:37

EM : Right click managment - SQL Server Agent : [Advanced] : Auto restart SQL if it stops unexpectedly

Ditto "SQL Server agent"

But I still don't trust the blighter - I had even this fail under SQL7. So we have an hourly batch file that "starts" them in case they are stopped. This is for SQL7/NT4, I haven't got a SQL2K one to hand:

net start SQLExecutive /Y >>D:\LOGS\BATCH.LOG
net start MSSQLServer /Y >>D:\LOGS\BATCH.LOG
net start MSDTC /Y >>D:\LOGS\BATCH.LOG
net start MSMQ /Y >>D:\LOGS\BATCH.LOG
net start SQLServerAgent /Y >>D:\LOGS\BATCH.LOG
net start CISvc >>D:\LOGS\BATCH.LOG
net start W3SVC >>D:\LOGS\BATCH.LOG
net start MSFTPSVC >>D:\LOGS\BATCH.LOG
net start IISADMIN /Y >>D:\LOGS\BATCH.LOG
net start "Microsoft SMTP Service" /Y >>D:\LOGS\BATCH.LOG

Kristen

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-18 : 16:29:45

Even with the stops unexpectedly option checked in EM, make sure the service is set to automatic in Services applet in admin tools in control panel.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources