Select from following answers:- Alerts
- Operators

- Contacts
- Notifiers
- All Above
SQL Server Agent allows us to notify the job completion/failure/succeeded status for the particular users by specifying Operators.
To set up the Operators for job status notification,
SQL server Agent --> Right-click on the job --> Properties --> Notifications --> Check the 'E-mail' option for the Operator to whom you wanted to notify job status.
Before setting this, you must create Operator by using 'Operators' under SQL Server Agent.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator