Post reply

Question about SQL Jobs

  • August 21, 2014 at 9:52 am

    #292488

    Hi,

    Does anyone know what might cause an enabled SQL Job with an active schedule not to run? I have a job that is supposed to run every 10 minutes that suddenly stopped.When I view the history, it has a last run time from a couple of hours ago. Other Jobs have more up-to-date last run times, so I don't think the SQL Server Agent itself stopped. If there were an error, I'd expect to see several failed attempts to run, but I don't. Any ideas?

    Thanks,

    Mike

    Mike Scalise, PMP
    https://www.michaelscalise.com

  • August 21, 2014 at 10:16 am

    #1739970

    The schedule also has an enabled flag. The schedule also may have had an end date.

    The probability of survival is inversely proportional to the angle of arrival.

  • August 21, 2014 at 10:31 am

    #1739973

    Also check what the Job Activity Monitor is showing for Next Run.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • August 21, 2014 at 10:49 am

    #1739978

    Might be a daft question, but is it still running (i.e. last run never finished)?

  • August 21, 2014 at 12:24 pm

    #1740007

    All,

    Thanks so much for the responses. It looks like a few jobs were still executing according to the Job Activity Monitor. One I stopped them, everything was back to normal.

    Thanks again,

    Mike

    Mike Scalise, PMP
    https://www.michaelscalise.com

Viewing 5 posts - 1 through 4 (of 4 total)

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