Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

If the job isn't running, something is wrong with the schedule. I suggest you script out the job (right-click, select "script job as" > CREATE TO > New Query Editor window) and edit your question to include the resulting script.
–
Ed HarperJan 26 '12 at 8:33

I have added the Drop/Create script as suggested by you.
–
PankajJan 26 '12 at 8:50

Please update the question with the latest version of the job script
–
Ed HarperJan 26 '12 at 16:17

2 Answers
2

As far as I can see your schedule is set to execute between midnight (12:00AM) to noon (12:00PM), i.e. your job will not execute in the afternoon and evening. Change your ending time to 11:59:59PM and it should run all day.

The job definition you have posted is configured only to execute between 20:32 and 21:59 in server local time. Check the local time of the server and confirm whether it's configured to be in the timezone you're expecting.

To remove this restriction, amend the schedule to run from 00:00:00 to 23:59:59.

EDIT

Try changing the schedule end time from 12:00:00 PM to 11:59:59 PM, just to be certain about the time frame