The Add Action Provider dialog box allows you to pick the action provider type you want to use for your alert response. The following choices are available:
Enable Query Monitor Action Provider
Enable the Query Monitor when the criteria of your Alert Response rule is met.
Email (SMTP) Provider
When the criteria for the new alert rule is met, SQLdm sends an alert email message to the SMTP server, which then forwards the message to the specified email address. SQLdm allows you to configure your email settings and configure your network management settings to properly route alert messages.
Idera Newsfeed Action Provider
Publish the alert message as a status update on the server wall in the Idera Newsfeed interface and on the Active Alerts view in SQLdm Mobile. For more information, see the Idera Newsfeed Help.
Network Management (SNMP) Trap Message Provider
When the criteria for the new alert rule is met, SQLdm sends an SNMP Trap message to the specified network management console. SQLdm allows you to configure your email settings and configure your network management settings to properly route alert messages.
Program Action Provider
Start a program when the criteria of your Alert Response rule is met.
SQL Agent Job Action Provider
Execute a SQL Agent job when the criteria of your Alert Response rule is met.
SQL Script Action Provider
Execute a SQL Script when the criteria of your Alert Response rule is met.
To Do Action Provider
Create a To Do Action when the criteria of your Alert Response is met. This option only displays when you have upgraded from SQLdm 6.x and previously enabled the To Do feature. This feature is deprecated in SQLdm 7.0 and later.