Home Forums SQL Server 2005 Administering how to giver users access to viewing JOB Activity Monitor RE: how to giver users access to viewing JOB Activity Monitor

  • Use the following to grant VIEW SERVER STATE to a user. With this permission, they can see Activity Monitor. Please research this permission to make sure it does not give other permissions that you do not wish the user to have.

    USE master

    GO

    GRANT VIEW SERVER STATE TO [<domain>\<username>]