Grant user to see the SQL Server job status

From: Swami (Swami_at_discussions.microsoft.com)
Date: 05/24/05

  • Next message: Jens Süßmeyer: "Re: Grant user to see the SQL Server job status" 
    Date: Mon, 23 May 2005 16:04:02 -0700

    Hi

    I need to grant permission to the user to see the sql server job status
    through Enterprise Manager. I did the following steps but still these users
    are not able to see the sql server jobs status. Even few jobs are running
    these users always shows as " not running" .

    1 Created a separate role to in MSDB to monitor daily sql servers jobs. In
    this role granted target server roles and execute permission to few stored
    procs which the user can start and stop .

    2 I dont want to give sysadmin rights to these users.

    Need your info

    Regards

    Swami

  • Next message: Jens Süßmeyer: "Re: Grant user to see the SQL Server job status"