Sunday, February 12, 2012

Alternative to operator notification?

I have a new SQL server, Windows 2003, SQL 2000.
I had planned on NOT putting MAPI on this server, given that it's been
troublesome in the past.
On my other servers, I have MAPI installed, and when it gave problems, I
switched over to a stored procedure to send email. I plan to use this
same stored procedure to send mail with this new one.
However, in the notification tab on the new jobs, it won't recognize
anything but a MAPI profile on that box (the same as the old ones). On
the old ones, we have MAPI running to send an email if the job dies,
while it uses the stored procedure to send reports out.
Is there an alternative to using anything other than MAPI for the
Operator Notification tab? If so, what?
Thanks,
BCHi
Have you checked out http://www.sqldev.net/xp/xpsmtp.htm? Rather than using
a notification you can use the GOTO STEP options on the advance tab to run a
specific step on failure or success, you can then call this procedure in tha
t
step.
John
"Blasting Cap" wrote:

> I have a new SQL server, Windows 2003, SQL 2000.
> I had planned on NOT putting MAPI on this server, given that it's been
> troublesome in the past.
> On my other servers, I have MAPI installed, and when it gave problems, I
> switched over to a stored procedure to send email. I plan to use this
> same stored procedure to send mail with this new one.
> However, in the notification tab on the new jobs, it won't recognize
> anything but a MAPI profile on that box (the same as the old ones). On
> the old ones, we have MAPI running to send an email if the job dies,
> while it uses the stored procedure to send reports out.
> Is there an alternative to using anything other than MAPI for the
> Operator Notification tab? If so, what?
> Thanks,
> BC
>|||In addition, another option with xp_smtp_sendmail and
operators is to use Db Maint SMTP Alerter. Check the
following:
http://www.dbmaint.com/SmtpAlerter.asp
-Sue
On Tue, 9 May 2006 10:14:02 -0700, John Bell
<jbellnewsposts@.hotmail.com> wrote:
>Hi
>Have you checked out http://www.sqldev.net/xp/xpsmtp.htm? Rather than using
>a notification you can use the GOTO STEP options on the advance tab to run
a
>specific step on failure or success, you can then call this procedure in th
at
>step.
>John
>"Blasting Cap" wrote:
>

No comments:

Post a Comment