January 30, 2012 at 8:03 am
I am using SQL 2005 SP2 Enterprise Edition.
Backup jobs are scheduled for the all the databases.
After getting alert for the one database, found that the backup job has not executed for some databases for more then 3 weeks.
There is no error in the event logs, no error captiured in the SQL logs also. Both the job and its schedule is enabled.
Any suggestions.
January 30, 2012 at 8:11 am
Can you start the scheduled job manually ?
January 30, 2012 at 9:21 am
And is the job running on the schedule and failing? Or just the one failure?
Are you sure the schedule is recurring?
January 30, 2012 at 10:17 am
Is SQL Agent running? I've seen this get shut down or not set to auto start.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 30, 2012 at 11:21 am
Check the job schedule in the job properties and make sure that it is enabled. I have seen sometimes you will have a job enabled but not its scheduled. You can see this in the job activity monitor and check the column 'Next Run'.
Blog
http://saveadba.blogspot.com/
February 1, 2012 at 8:17 am
Does the code in the job have error handling ? If it does, then it might be worth looking at how the errors are being handled / ignored.
Cheers
Vultar
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply