You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.

Understanding SQL Server Agent SQL Server Agent is a popular tool from Microsoft for scheduling programs to run on Microsoft's SQL Server database platform.

In addition, SP3 includes patches for known vulnerabilities reported by users or discovered through testing, as well as the ability to run SQL Server Agent as a non-administrator.

For security, Microsoft has added the ability to run SQL Server Agent as a non-administrator and updated online documentation with more guidance for securing SQL Server.

SQLPAL's Win32 support is not complete—around 1 percent (81MB) of Windows libraries are used, with SQLPAL itself being another 8MB—but it's sufficient to run MSXML, SQL Server Agent, and many ...