February 10, 2006 at 6:49 am
Hi,
I've just noticed that for one of our scheduled jobs that runs a DB Maintenance Plan, the "Next Run Date" column in the listing of jobs shows:
"Data and time are not available"
I'd be curious to know why that is occurring given that I have never noticed it before.
Thanks
February 10, 2006 at 6:57 am
I can think of below reasons:
1. Job is not scheduled to run
Below is the procedure which runs in background.
sp_help_job, this in turn executes below.
EXECUTE master.dbo.xp_sqlagent_enum_jobs 1, dbo
HTH
February 10, 2006 at 7:12 am
That is what I immediately thought to check. But ithe job is both enabled and scheduled, and to double-check I just run it manually and the quirk still persists.
February 10, 2006 at 7:17 am
1. Who is the owber of the job? (Windows account or sa)
2. Whats is the startup account of SQL Server and SQL Agent?
3. By which account you connected to SQL Server Enterpise manager?
February 10, 2006 at 8:39 am
Sometimes the job needs a Refresh to update that value. Especially if any changes have been made to the job.
-SQLBill
February 10, 2006 at 8:42 am
Yup, tried the refresh too, but no luck. Still need to go back and check all the various accounts, but not sure how/why that would affect ONLY 1 of the 4 scheduled jobs which execute DB Maintenance Plans
February 10, 2006 at 10:02 am
The job needs to be enabled AND the schedule needs to be enabled. Perhaps the job had an end date that has now passed.
February 10, 2006 at 10:13 am
....he he he he. Now that is the ONLY thing I did not check. The schedule was in fact disabled. Thanks for that. Seems like a good question of the day...
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply