A few years ago I gave you homework to create a SQL Agent Job and play with it a little bit. This month I want you to either take that job (or another) and work with it a bit more. We are also going to play with a few other parts of the SQL Agent.

• What is the SQL Agent running under? (5 pts)
• Do some reading on why we care. (5 pts)
• How far back does your job history go? For this job and/or all of your jobs combined? (5 pts)
• Extend that history out some. (5 pts)
• Open the Job Activity Monitor and look at what it shows you. (5 pts)
  • Right click on a job and view the history or open the properties. (5 pts)
• Create a proxy. (20 pts)
• Make at least one step in your job run off of the above proxy. (10 pts)
• Look all of the proxies that can run a CmdExec job step. (5 pts)
• Create an Operator. (5 pts)
• Create 2 different types of Alerts.
  • One should notify the Operator you just created. (5 pts)
  • The other should start your job. (5 pts)
  • Test the alerts to make sure they work. (10 pts)
• Go back to the Operator and make sure they are going to be emailed (or paged) for at least one of your alerts. (5 pts)
• Open the SQL Server Agent log. Skim through at least some of the data. (5 pts)