Creating SQL Server Agent objects
In the previous sections, we described how to configure an environment for automation. Maintenance plans were also discussed in detail in the previous section. However, what is working behind the scenes? How do we automate some specific tasks? 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 can be used for regular emailing, their main purpose is to use emails for administrators' notifications about job results or when some alert is raised. SQL Server Agent does not notify directly to an email address; it uses a special object called an operator. The operator is a named address defining where to send notifications mainly about job results.
The address...
