SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

DML Triggers to track SQL Server Agent Jobs creation, deletion and modification events

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 are scheduled to run on a daily, weekly or monthly basis on our various SQL Servers. These jobs are very critical, and as a database administrator, my responsibility is to ensure that these jobs are running every day, or on a weekly, or monthly basis and no unauthorised changes have been made to these jobs. I also need to know, who and when a SQL Server Agent Job is created, deleted or modified on my SQL Server? Obviously this is not an easy task to perform manually and there are not many options available in SQL Server to monitor such kind of activity. As a result, I have decided to build my own monitoring solution that automated this task with the help of DML triggers, which helps me to monitor SQL Agent Job modification activity in real-time.

Checkout my article here, which shows step-by-step implementation of this monitoring solution, which performs real-time monitoring of SQL Server Agent Jobs creation, modification and deletion activities.

This article is published on SSWUG.org.

Basit's SQL Server Tips

Basit Farooq is a Lead Database Administrator, Trainer and Technical Author. He has more than a decade of IT experience in development, technical training and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles, and developed and implemented many successful database infrastructure, data warehouse and business intelligence projects. He holds a master's degree in computer science from London Metropolitan University, and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.


Leave a comment on the original post [basitaalishan.com, opens in a new window]

Loading comments...