Post reply

Minimum permissions to run PowerShell script.

  • September 21, 2012 at 4:18 am

    #262032

    Hello All,

    Does anyone know what are the minimum permissions required to run a PowerShell script that produces a SQL Agent Job status report? We have been able to run a script that checks database backup status with minimum permissions but the one that checks SQL Agent job status only produces an output when the user is a member of the SysAdmin server role? We do not want the id to have such high level permissions therefore any help would be highly appreciated.

    Thanking you in anticipation

    Kailash.

  • September 21, 2012 at 7:03 am

    #1540660

    SQLAgentReaderRole should be enough to view job history.

  • September 21, 2012 at 7:46 am

    #1540697

    Thank you, thats great and has done the trick.

    kind Regards

    Kailash.

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

You must be logged in to reply to this topic. Login to reply