Scheduling with the SQL Server Agent A few practical examples on setting up policies. This time, we PowerShell it. By Joshua Jones 12/07/2009 It is possible to use the SQL Server Agent to execute ...

Select the the field next to Specify a Startup Parameter and then enter "-m" -- without the quotes. Click "Add," then "OK." Restart SQL Server to run the instance in single-user mode.

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.