The SQL Server Agent is the scheduling tool for Microsoft SQL Server 2012, and you must at minimum learn what a job and an alert is. If you donâ€™t know that, and if you canâ€™t setup a simple job and an alert, then you will not pass the exam.
When you have learned the basics of alerts and jobs, then you must learn
- How to setup the database mail option in the SQL Server Agent.
- NotificationsÂ and schedules on jobs
- Setting up a proxy and use it in a job step.
- Multi instance management.
You must also understand the impact of the account you have setup the SQL Server Agent Service with.
I forgot to mention one thing in the demo, and that is if you are not a member of the sysadmin, then you must be member of a specific role in the MSDB database: