-
Sql Agent Jobs skipping schedule
I had to shut down my sql agent for 2-3 hours for maintenance purpose .
After I brought up the agent I found that some User Jobs that were suppose to run hourly did not run on their next scheduled hour.
On rebooting the server the Job started to run again every hour as scheduled.
There were no error messages in Sql Agent log except this message
An idle CPU condition has not been defined - OnIdle job schedules will have no effect
Any help appreciated?
-
Did you stop the agent when the job already started because every time when the job runs it sets the NEXT RUN DATE.
-
Thanks for the reply.
No the Sql agent was stopped after the Job ran at that hour.
Here is the sequence of events.
1:00 AM Job ran
1:05 Agent down
3:10 Agent up
4:00 Job did not run
5:00 Job did not run
6:00 Job did not run
6:30 Server reboot
7:00 Job ran
-
Thanks for the reply.
No the Sql agent was stopped after the Job ran at that hour.
Here is the sequence of events.
1:00 AM Job ran
1:05 Agent down
3:10 Agent up
4:00 Job did not run
5:00 Job did not run
6:00 Job did not run
6:30 Server reboot
7:00 Job ran
-
Let me ask you a series of questions.
1. What SQL Server version 7.0 or 2000?
2. What service pack
3. Was the Job enabled?
4. Was it on a cluster server?
5. Anything on the eventviewer or sql errorlog
-
This is Sql Server 2000 box with Service pack 2 and this is not a Cluster Server
The event log did not had any messages.
The Sql agent error log just had this message
An idle CPU condition has not been defined - OnIdle job schedules will have no effect
One thing noted was that the DB Maintenance Jobs(log backup) which also runs every hour, did run as scheduled after the agent was brought up
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|