March 21, 2007 at 8:03 am
Hi Gurus,
There are three servers, my customer is owner of few databases on all the three servers, he doesn't have sa privilege on the servers. There are few jobs on all the three servers, initially he was not able to view the jobs, then i granted MSDB-TargetServerRole privilege to him along with EXEC privilege. All the jobs are scheduled to run everyday.
Here the issue is, in the SQL Agent-Jobs window, the "Next Run Date" column showing "Date and Time are not Available", even it is a scheduled job. I've checked all upto my knowledge. No Luck.
Can anyone help me to resolve the same.
If I get the update soon, that would be more appriciated...
Thanks in advance....
warmest, Jayakumar K.
Thanks
Jay
http://www.sqldbops.com
March 21, 2007 at 8:05 am
Did you enable the job and the schedule?
Did you refresh after changes were made?
March 21, 2007 at 8:08 am
Yes it is scheduled job. If i loggin to the server, i'm able to see the next run date and time, because i'm SA. But my customer is only DB owner for specific databases.
One more thing i've to specify here, all the three servers are different regions, so he registered the sql servers in his local desktop.
Thanks.
Thanks
Jay
http://www.sqldbops.com
March 21, 2007 at 9:22 am
I'm not entirely sure what's wrong, but I'd suggest running a trace when you access the job list in EM and one when your assistant does and compare them. Likely if you grant a few additional rights, like SELECT, to some of the tables, it will work.
March 24, 2007 at 2:57 am
Steve im suspecting one more point here, the owner of the job is diffent login and accessing the job is differnt login (affected person). Will it be the cause of this issue?
Thanks
Jay
http://www.sqldbops.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply