SQL Agent jobs not running as scheduled

Question

SQL Agent jobs not running as scheduled

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Jared SSC Guru Points: 61793 More actions · Answer 1

Sheila.Roscoe (10/26/2011)
just fyi...this is a virtual server. We have another virtual server, same version of SQL, and the jobs have been running fine since creation of the jobs.

Have you looked at the windows logs on this virtual instance? Is it possible that something on the OS is conflicting with this specific time? It just seems very strange that the job will only not kick off at 10PM. Even if another agent job was conflicting, it would not stop the agent from starting the job, it would only increase the duration. At worst it would still show an error that you have said you have not seen.

Thanks,

Jared

Jared
CE - Microsoft

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 2

jared-709193 (10/26/2011)
Kenneth Fisher-475792 (10/26/2011)
First let me point out that people trying to help out on this form are shooting blind. We have to start at the beginning and assume nothing. Honestly if I'm trouble shooting for people on my own team I would start at the same place that Jared did. All that being said, would you please script out your job/schedule and post them?
And as other tests you could run have you tried 10:01 PM? or 10:30 PM? 9:30 PM etc? Have you checked to see if there is another job running at the same time that may be interfering? Its odd that it won't run when you set it to 10 PM but will run at other times.
Kenneth
I'm not sure why you think I was shooting blind, in fact not knowing the level of knowledge of the OP I was gathering all information about the set up that I could. All too many time people have a job disabled or even the schedule disabled. Clearly the OP has a good knowledge of SQL Server, but I did not know this at first.
Jared

Sorry, I didn't mean shooting blind as lack of experience. I meant in terms of not knowing the layout of the server, or the setup. That you have to start right at the begining, explore the simple stuff first, then move on to harder. Like I said, I would probably start out with similar questions even knowing the level of knowledge of the OP, just because sometimes people make simple mistakes, and those are often the hardest to find.

Kenneth

Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 3

Since its a new virtual machine have you checked with your server admin to see if any changes have been made to the server recently?

I find it odd that in your original post you said that it ran once at 10 PM then ran the next time at 5:04 AM. That sounds like something changed between the 2 runs.

When you have recreated the jobs have you used the existing schedule or have you dropped and recreated that also? In SQL 2008 schedules are actually stored separate from the jobs. If you right click on the Jobs heading you will see any entry for "Manage Schedules" that you can use to see all of the existing schedules.

Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

Sheila.Roscoe Mr or Mrs. 500 Points: 510 More actions · Answer 4

I completely deleted the jobs and schedules and then recreated them. The job just ran successfully at 12 pm, so I am going to change the schedule again for later this afternoon. I did ask the server admins about the time difference and they stated that there were no issues on their side. It just puzzles me why it will run at certain times and not others. We use NetBackup on this server and I am not bumping heads with it.