Tutorial :What is use of operators and alerts in SQL server management studio?


Can anyone explain why and where to use operators and alerts in SQL server management studio?


Operators and alerts are intended to support SQL Server jobs, which in turn are managed by the SQL Server Agent.

Lets say you had a SQL Server instance that processed a significant number of jobs. You may want to assign a particular operator responsiblity for certain jobs and so choose to inform them of the status of these jobs i.e. a member of the Finance Team might be responsible for a job that produces invoices.

The following reference details how to create operators.


Hope this makes sense but do please feel free to contact me directly if you need further assistance.

Cheers, John

Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Next Post »