July 19, 2002 at 9:38 am
SQL 7.0: Is there a way to allow multiple users to view the jobs and the job status from EM other than granting them SA rights?
July 19, 2002 at 9:55 am
Maybe serveradmin?
Or build some job to extract the info into a table every xx minutes.
Steve Jones
July 19, 2002 at 10:54 am
Dont see why you cant just change the permissions on sysjobs and sysjobhistory. Let them query directly or put a simle asp page that will show them.
Andy
July 19, 2002 at 11:41 am
I like the idea of changing the permissions on sysjobs and sysjobhistory and let them query directly. I'll try that and see if it works for the users.
July 19, 2002 at 5:47 pm
Best in my opinion is to create a Role ofor the msdb database and set it with SELECT rights on those 2 tables. Then you can add and remove users as needed. Or even better instead give them exec access to sp_help_job and/or sp_help_jobhistory (see BOL for more details). The only reason is so they somewhat have it where they can get the data without much fuss.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply