Minimum SQL Server role to check SQL Agent status with PowerShell?

Question

I need to execute the PowerShell to remotely check the SQL backup job status on each SQL Database instance across multiple SQL servers but as a Read Only user account.
What are the minimum credentials or SQL Server role that I can use to query the SQL Agent backup job status?

The PowerShell script:
https://learn.microsoft.com/en-us/powershell/module/sqlserver/get-sqlagentjob?view=sqlserver-ps
https://learn.microsoft.com/en-us/powershell/module/sqlserver/get-sqlagentjobhistory?view=sqlserver-ps

Executed from my workstations with https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

Any help with script examples will be greatly appreciated.

Answer 1

A member of SQLAgentReaderRole role allow the user to see any SQL Agent job located on the server instance, even the jobs in which that user does not own. The user can see the job, along with any history saved to the job. However, the group is not allowed to execute the jobs