SQL Server often requires the need to run tasks during low peak times as well as the automation of tasks such as for data loading, maintenance tasks, and more. The use of SQL Server Agent is key to setting up automation, but what are the best practices and techniques for setting up and managing your scheduled tasks?
In this webcast, we will at how to take advantage of SQL Agent features such as: Scripting jobs to deploy jobs to your servers Categorizing SQL Agent jobs Using Database Mail, notifications and alerts Querying system tables to generate your own reports System stored procedures to work with SQL Server Agent Master / Target servers and more Join us for this webcast to learn how make SQL Server Agent work for you.
Ben DeBow is an experienced consultant who works with customers of all sizes on their mission critical applications and SQL Server deployments. His versatility allows him to assist with everything from virtualization and consolidation to schema design, performance tuning, disk architectures, and everything in between. He has tuned and deployed some of the largest and most complex SQL Server solutions in the world. An active member of the SQL Server community, Ben is also the CEO of Fortified Data and can be reached at http://www.fortifieddb.com.
Topics: Database Monitoring, Database Administration Products: SQL Enterprise Job Manager