sp_ValidateJobEnabled
Check if a SQL Agent job exists and is enbled.
Parameters:
@JobName - Name of the job to validate.
Usage:
EXEC [Util].[sp_ValidateJobEnabled] @JobName='MyJob'
Page Last Updated: 21 September 2025
Technical details for Utility Procedures used by dbOmnibus.
| Procedure List |
These utility procedures are used internally by dbOmnibus and are not intended to be executed manually.
Check if a SQL Agent job exists and is enbled.
Parameters:
@JobName - Name of the job to validate.
Usage:
EXEC [Util].[sp_ValidateJobEnabled] @JobName='MyJob'