Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Custom Job Manager Role

    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)

    ...

  • RE: Custom Job Manager Role

    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...

Viewing 2 posts - 1 through 2 (of 2 total)