How can you better manage a large number of SQL Server agent jobs?

by Aug 14, 2020

Managing a large number of SQL Server agent jobs across a large enterprise environment can be difficult and frustrating. Database administrators are often asked to schedule jobs for a variety of SQL processes and SQL Server Integration Services (SSIS) packages with little or no insight into what the processes or packages will be doing. Scheduling packages blindly can often yield performance problems from jobs that try to use the same resources or access the same data structures at the same time. Job overlap can be difficult to find and can cause a lot of problems.

Read the 9-page whitepaper “3 Tips for Managing Large Numbers of SQL Server Jobs to learn about shares the author’s three top tips for managing a large number of SQL jobs and SSIS packages. These tips will make administering the jobs easier and prevent common problems that are inherent in a large SQL job environment. (1) Centralize the SQL job servers onto dedicated servers. (2) Utilizing the new SSIS catalog in SQL 2012 and newer. (3) Use a third party tool that can give you the big picture and let you look at your SQL job environment as a whole. These tips will make administering a large number of jobs easier, alleviate some common resource issues with executing many SQL jobs, simply troubleshooting SSIS package failures, and bring the problems in your environment into a single view.

Click here to download the PDF file.

The presenter, Robert L. Davis, was a senior database administrator and technical lead at Microsoft. He was a speaker and a trainer as well as a writer for SQL Server Magazine, and co-authored "Pro SQL Server 2008 Mirroring" (Apress). Blog Twitter @sqlsoldier.