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



Question:

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


Solution:1

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.

http://www.mssqltips.com/tip.asp?tip=1523

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
Previous
Next Post »