SQL Server Agent objects

In previous sections, we described how to establish an environment for automation and Maintenance Plans were discussed in detail. However, what's working behind the scenes? How to automate some specific tasks that may be assigned? In this section, we will take a look at three types of objects that actually participate in automation:

• Operators
• Jobs
• Alerts

Operators

One of the first tasks when setting up an automation environment is the enabling of database mail and mail profile creation. Although mail profiles could be used for regular emailing, their main purpose is to use emails for administrator's notifications about job results or when some alert is raised. SQL Server Agent does not...