November 23, 2007 at 3:48 am
We have a number of jobs on one server that runs under SQL Server Agent. However there is one job, that is schdeuled like all the others, but displays 'Date and time are not available' and hasn't run on the last two occassions without manual intervention.
Has anyone got any clues?:Whistling:
Madame Artois
November 23, 2007 at 4:05 am
Check whether this job has a schedule and also enabled.
--Ramesh
November 23, 2007 at 4:22 am
It is scheduled and enabled just like all the others.
:Whistling:
Madame Artois
November 23, 2007 at 4:46 am
Is this job a recurring one?
Is the schedule of job enabled?
Do you find any relevant information in job history or error log?
--Ramesh
November 23, 2007 at 5:02 am
Thanks guys. We found it. Although the job was enabled, someone had disabled the job!
The hunt for the offending person will now commence!
:Whistling:
Madame Artois
November 23, 2007 at 5:04 am
Whoops sorry. Someone had disabled the schedule not the job. Please put my error down to the steam coming out of my ears!
:Whistling:
Madame Artois
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply