Results 1 to 6 of 6

Thread: Sql Agent Jobs skipping schedule

  1. #1
    Join Date
    Sep 2002
    Posts
    9

    Question 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?

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Did you stop the agent when the job already started because every time when the job runs it sets the NEXT RUN DATE.

  3. #3
    Join Date
    Sep 2002
    Posts
    9
    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

  4. #4
    Join Date
    Sep 2002
    Posts
    9
    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

  5. #5
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    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

  6. #6
    Join Date
    Sep 2002
    Posts
    9
    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
  •