For Databases
SQL Server Oracle Sybase DB2
For Cloud Services
AWS Azure
For Applications
SAP Applications PeopleSoft

Return to list Return to list

Whitepaper: 3 Tips for Managing Large Numbers of SQL Server Jobs

  • Centralize the SQL job servers on to dedicated servers
  • Utilizing the new SSIS catalog in SQL 2012 and newer
Author: Robert L Davis
Published: September 30, 2014
Tags:  Administration SQL SQL Server

This whitepaper is a guide for DBAs on managing and scheduling large numbers of SQL jobs across a SQL Server enterprise.

Managing a large number of SQL Server 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 SSIS packages with little or no insight into what the processes or packages will be doing. Scheduling packages blindly can often yield to 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.

Register For a Free Whitepaper