SQL Jobs Displaying "Date and Time is not available"

Question

SQL Jobs Displaying "Date and Time is not available"

hll

SSC-Addicted

Points: 470
More actions
May 18, 2004 at 4:48 pm

#152151

We login to our sql server with our windows accounts and can look at the sql agent jobs in enterprise manager via the msdb.targetserverrole membership; however, the "Next Run Date" on all of the jobs shows "Date and Time are not available". I have tried placing our accounts in every server role and database role, but the message still displays. The only role that will resolve the problem is the System Admin role and our windows accounts cannot have this membership as it does not appeal to our auditors.
Can anyone shed any light on this anomally?
Thank You, Lloyd

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

sharrell SSC-Addicted Points: 477 More actions · Answer 1

Hi Lloyd,

The targetserverrole group doesn't have access to the sysjobschedules table by default, which is where this information is stored. You need to add select permission on the table to that role.

Regards,
Steve

Meddle not in the affairs of dragons, for you are crunchy and taste good with ketchup.

sadheesh kumar m Old Hand Points: 385 More actions · Answer 2

In this job msdb.targetserverrole u not mentioned the next run date that is a reson display date and time not available.Check that job next run date.

dmoore2168 SSC Journeyman Points: 88 More actions · Answer 3

I have checked the sysjobschedules and the next run date is there, but when I run sp_help_job the next run date does not show. I have also checked the targetserverrole member and it does have select permissions, however, in EM, the Next Run Date is still showing, (Date and Time are not available).

Any other ideas?

Thanks,

DMo

Martin TRemblay-161683 SSC Veteran Points: 233 More actions · Answer 4

Like Newbie I have the axact same problem. 2There is no next run date! Further more, I cannot start manually anny job. The next run date is in sysjobschedules but not in sp_help_job. I really need some help!!!!!

martin.tremblay@wanadoo.fr

m.tremblay@mobilesoft.fr