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 notify directly to an email address, it uses a special object called operator. Operator is named address defining where to send notifications mainly about job results.
The address of the operator may be as follows:
- Email address: Person, more people, or distribution group can be set as an...
