Bill (DBAOnTheGo) (1/2/2014)
I would just right click the job, go to schedules, select the schedule, and hit edit.See if the schedule type is listed as recurring, see if the Enabled box is checked, verify the frequency, verify there's no hard set end date that will mess it up....
If all else fails, remove the schedule and make a new one.
You've verified that the job didn't run at all correct and not that it didn't just run and fail.
Yes, it looks fine to me. There's no end date, it runs monthly, on day 1 of each 3 months, at 12:05 AM. The start date was 1/1/2009, when I created it 5 years ago. The schedule type is recurring. Now, I don't know how to tell when SQL Server will run it again. Is there some way I can find that out? It should run it next on April 1, 2014 at 12:05 AM.
As far as knowing whether or not it ran, I've got another job which runs daily to track our draw down of funds. This quarterly job should have added new funds to a table, but it didn't. Furthermore, there's no history in SQL Server Agent | Jobs for the "Add Quarterly Allotment" SQL Job.
Kindest Regards, Rod Connect with me on LinkedIn.