Viewing Jobs

Last Post 07 Mar 2008 07:43 AM by prospec. 10 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
lslmustang
New Member
New Member

--
25 Aug 2005 04:31 AM
We have on production jobs that are owned by a system admin account in order
to run jobs that entail more permissions than users have. This has worked
well but several of our analysts are regularly asking if a job is there
because they can't see the jobs. We want to create a role in msdb called
jobviewer, with deny permissions on things like sp_start_job or sp_create_job,
but we want them to be able to see all jobs.
Is there a way to do this?
I tried testing altering sysjobs_view on my local machine to test out if altering it would
yield all the jobs and found no matter what I did to that view, it always returns only the
jobs the user owns (unless it's me the admin). If I add them to the
TargetServersRole, they can see all the jobs but we don't want them in that
role.
Any suggestions?
lslmustang
New Member
New Member

--
25 Aug 2005 04:36 AM
TargetServersRole has too much permission. We use that for people to be able to run jobs. We don't want these users to be able to run jobs.
lslmustang
New Member
New Member

--
25 Aug 2005 05:29 AM
That didn't work :-(
Any other ideas?
lslmustang
New Member
New Member

--
25 Aug 2005 05:56 AM
I tried it on a SP3a machine and a SP4 machine and no go :-(
lslmustang
New Member
New Member

--
25 Aug 2005 07:25 AM
We modified that for our folks that need to run jobs so it can start jobs. We have job runners and we want job viewers. I think I'll just create a role that deny sp_start_job etc. and add them to our TargetServersRole too.
prospec
New Member
New Member

--
06 Mar 2008 11:24 AM
What would be the perm to allow a user to view the status of the job. to see if the job is currently running.
prospec
New Member
New Member

--
06 Mar 2008 01:54 PM
Hi RM,
I did do that but the user is still unable to see the status of the job that is running. Not sure why that is.
SQLUSA
New Member
New Member

--
06 Mar 2008 09:58 PM
How about a stored procedure to check job status?

Or send an email at start and end?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
BI Workshop NYC SSIS, SSRS, SSAS - March 17-20: http://www.sqlusa.com/
prospec
New Member
New Member

--
07 Mar 2008 07:43 AM
SQLUSA - I guess that would work to but that would require me to develop the process right now I'm too busy to do that. It would be easier for me to just let the user us their UI to view the status of the job. Plus it's a kind of situation where they want it yesterday.


RM - here is the version.
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
prospec
New Member
New Member

--
07 Mar 2008 02:47 PM
Granted exec on msdb..sp_enum_sqlagent_subsystems and it still didn't work....maybe it's a service pack issue.
SQLUSA
New Member
New Member

--
08 Mar 2008 12:07 AM
Andy is right about the new role. SQL Server 2008 has it also.


Related topic:

http://sqlforums.windowsitpro.com/w...erthread=y


Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
BI Workshop NYC SSIS, SSAS, SSRS - March 17-20: http://www.sqlusa.com/
You are not authorized to post a reply.

Acceptable Use Policy