Viewing 2 posts - 1 through 2 (of 2 total)
I forgot to send the code changed 🙂
ALTER 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)
...
May 14, 2008 at 2:28 pm
#815539
Hi guys
I had the same problem. The database roles created by me didn't work...
To fix this problem you have to change a view: msdb.dbo.jobs_view including your new role. Here the...
May 14, 2008 at 2:26 pm
#815538