Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Permissions on Scheduled Jobs
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 9th March 11:31
trayce jordan
External User
 
Posts: 1
Default Permissions on Scheduled Jobs



It can be done, but you have to modify certain "shipped" items from MS.
In the MSDB, under views, you would need to modify the view: SysJobs_View
and change the where clause to whatever you believe suits you best. It
could be a database role that you grant to individuals and you give them
that permission, you could eliminate the where clause altogether, etc. etc.
etc.

CREATE VIEW sysjobs_view
AS
SELECT *
FROM msdb.dbo.sysjobs
WHERE (owner_sid = SUSER_SID())
OR (ISNULL(IS_SRVROLEMEMBER(N'sysadmin'), 0) = 1)
OR (ISNULL(IS_MEMBER(N'TargetServersRole'), 0) = 1)

I think you'll also have to do somehting similar for executing, but I can't
remember the stored proc at the moment.

Trayce
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright © 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666