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...

DML Triggers to track SQL Server Agent Jobs creation, deletion and modification events (Part 1) Author: Basit A. Farooq Introduction to Problem As we know, SQL Server Agent jobs are crucial to any SQL Server environment, as they are used for scheduling and performing critical business and operational tasks. For example, I’ve got several hundred SQL Server Agent jobs that...