DML Triggers to Track SQL Server Agent Jobs Creation, Deletion and Modification Events (Part 2)

DML Triggers to track SQL Server Agent Jobs creation, deletion and modification events (Part 2) Author: Basit A. Farooq Now that we have created our tables, the next step is to create the four triggers to monitor and log any job modification activities that are occuring on SQL Server instance: 1) AuditDB_AuditNewSQLAgentJobTrigger – will trigger, when the new job will…