what is use of operators and alerts in sqlserver nmanagement studio

Question

Hi

Can any one explain whyand where to use operators and alerts in sqlserver nmanagement studio

Answer 1

Hi Ravi,

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