December 10, 2008 at 12:23 pm
I have a group that needs the ability to view, stop, and start sql jobs. I put them in the TargetServersRole in the msdb database and have given them extra permissions to start and stop jobs, but I can't find a way to make the "Next Run Date" show up in enterprise manager. All of the next run times show up as "Date and Time are not available".
Is there a stored procedure or table that I could give them execute or select permissions on to accomplish this task, without giving them system administrator privileges?
Thank you
December 10, 2008 at 12:52 pm
Try giving TargetServersRole permission to execute sp_help_jobschedule in msdb.
Greg
December 10, 2008 at 1:14 pm
TargetServersRole already has execute permissions on sp_help_jobschedule.
January 2, 2009 at 3:17 pm
I am having the same problem with the "Next Run Date" column for SQL Server Agent Jobs displaying "(Date and Time are not available)". Also, when first opening Enterprise Manager and drilling down to the Jobs, they take about a minute or so to display any info. The service account that SQLSERVERAGENT runs under is a sysadmin and local admin on the SQL server and seems to have the proper rights to read the info in the 'msdb' database regarding the job details.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply