Duration: 60 minutes
Track: Enterprise Database Administration & Deployment
Automation is a key part to becoming a great DBA. Without automation a DBA can start to drown in a sea of repeating tasks. The SQL Server Agent can serve as the much-needed life preserver to pull your head above the water. In this session you will learn at how to setup the SQL Agent as well as creating jobs and alerts within the agent to help you automate daily, monthly, yearly tasks. In addition we will look into how to monitor the jobs and alerts created. Lastly we will talk about some common pitfalls to watch out for when dealing with the SQL Server Agent.
To access the session recording, please login or register first:
Not a PASS member? Click here to register.
Database Administrator, TicketCity
Lance Tidwell works as a multi-hatted DBA for TicketCity.com for the last 7 years in Austin,TX. Where he has had to work on many sides of the database from development to creating backup/restore... View More