Notify Operator Task
The Notify Operator task sends notification messages to SQL Server Agent operators. For this task to work properly, you need to have SQL Server Agent service working; for the task to show you the list of operators, you need to have operators defined in SQL Server Agent and assign them an e-mail address. This task lists only users that have an e-mail address associated with them.
Following is the step by step method to configure this task:
1. | Drag and drop this task on the Control Flow panel of your package, and then connect to the SQL Server. This task uses the ADO.Net (SqlClient Data Provider) Connection Manager to create a server connection. |
2. | Select the operators you want to notify from the list, as shown in Figure 5-37 ... |
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
