reasons why a scheduled job may not have run

Posted on 2014-07-15
Last Modified: 2014-07-16
the instance is online and the dbs also..

but the job which is scheduled to run has not run..

the schedule is enabled too..
the agent is running...

what else could be wrong?
Question by:25112
    LVL 68

    Assisted Solution

    Is the job enabled?

    Was the job already running?  SQL will only run one instance of a given job at a given time.  If the job is already running, the start is ignored.
    LVL 65

    Assisted Solution

    by:Jim Horn
    The job is not enabled
    The checkbox to 'run only when the user is logged in' is checked, and the user is not logged in
    The user that runs the job does not have privs on that job/some object that the job calls
    The job timer is set to a time that either hasn't happened yet, or was in the past
    The batch file that you're executing has a typo where it is not running whatever you want it to run
    The job did run and threw an error (if this is a .bat, add & PAUSE to the end of the bat, and manually execute to view the results)
    The job did run and nothing happened, as designed
    The job did run and is not leaving any evidence that it ran
    The job is pointing to a different server / database / folder / whatever that you are expecting
    LVL 5

    Accepted Solution

    Are the credentials correct?  Any information in the event logs?
    LVL 5

    Author Comment

    thanks for the helpful pointers..

    it helped to revisit every step..

    what it was that even though the agent 'seemed' to be running.. it was (had) stopped somehow.. (that is another issue)..
    i restarted the agent and the scedhuled job picked up..

    thanks again.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now