|
Hi everyone, I am having problem with my Jobs which are created under SQL Job Agents, it was working fine for ages and start from last week, all the jobs NEXT RUNNING DATE are changed to 'Date and Time and Not Available' for all jobs. I have restarted the Agents but still problem is exists. Anybody know how to resolve this issue? Thanks.
(comments are locked)
|
|
Open each job and look if it is enabled, and if it has a schedule, and what the schedule looks like. Sounds like something happened around there. Yes, all enabled and has a schedule. I have create a new job and come up with the same problem when I click on Save.
Jan 19 '10 at 11:03 AM
Leo
In that case this might be the problem: http://support.microsoft.com/kb/825042
Jan 19 '10 at 11:30 AM
Steinar
(comments are locked)
|
|
Hi Guys... Thanks for your help. I restarted my Server last night and now problem is solved.
(comments are locked)
|
|
Is there anything in the agent logs that might indicate an issue? Did the restart actually start the agent successfully without error? Yes. It is restarted without error.
Jan 19 '10 at 11:04 AM
Leo
(comments are locked)
|
