11/12/2009, 12:39
|
 | Colaborador | | Fecha de Ingreso: julio-2007 Ubicación: Mexico, D.F.
Mensajes: 6.482
Antigüedad: 17 años, 7 meses Puntos: 180 | |
| Respuesta: Notificaciones Automaticas
Las instrucciones son estas:
Instructions:
Download and install xp_smtp_sendmail from SQLDev.Net.
Download the files for Db Maint SMTP Alerter. There is no installation program, just download the zip file, create a directory and extract the files to this directory.
Use Enterprise Manager to create the operators. Specify an email address for each operator. Important: Disable each operator. If you don't disable the operators, then SQL Server Agent will also try to send mail to them and write failure messages tn the eventlog.
Create the desired alerts in Enterprise Manager. For each alert, specify the operator(s) you want to be notified.
Run the client (DbMAlerterClient.exe) to create the needed tables in msdb, and also configure the SMTP mail settings.
Schedule the server (DbMAlerterServer.exe), which will read the eventlog and submit email to the operators as configured. Recommended scheduling interval is between once per minute to once per 10 minutes. DbMAlerterServer.exe will attempt to login to the SQL Server using Windows logins and it takes one command-line parameter: the name of the SQL Server to connect to, as in |