Hi
Can any one explain whyand where to use operators and alerts in sqlserver nmanagement studio
From stackoverflow
-
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
John Sansom : Are you refering to 'Failure Notification' within a SQL job? If so then no email is returned when a job successfully completes.
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.