Job step: Verify that automation is enabled.

CollapseAll image

Collapse image Job step properties


 Id   Name 
Name Verify that automation is enabled.
ID 1
Type TSQL
Run as user  
Database master
On success action 3 (goto next step)
Retry attempts 0
Retry interval(minutes) 0
On fail action 1 (quit with success)
Output file  

Collapse image Command


IF (msdb.dbo.fn_syspolicy_is_automation_enabled() != 1)
        BEGIN
            RAISERROR(34022, 16, 1)
        END

Collapse image See also


[syspolicy_purge_history]