[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

reasons why a scheduled job may not have run

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?
0
25112
Asked:
25112
3 Solutions
 
Scott PletcherSenior DBACommented:
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.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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
Gremlins
0
 
amac81Commented:
Are the credentials correct?  Any information in the event logs?
0
 
25112Author Commented:
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.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now