This procedure checks the SQL Agent run status and returns the result in an output parameter.

Note that this function is shared between Minion modules.
 
Name Type Description
@ServiceStatus bit

Output column that returns the state of the SQL Agent service: running (1), or not running (0).

Example Execution

DECLARE @ServiceStatus BIT;
EXEC Minion.DBMaintServiceCheck @ServiceStatus = @ServiceStatus OUTPUT
SELECT  @ServiceStatus;