9th March 11:31
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.
CREATE VIEW sysjobs_view
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.