Alternative to operator notification?

9 May 2006 4:44 PM

Blasting Cap

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

9 May 2006 5:14 PM

John Bell

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 that
step.

John

Show quote

"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
>
>

11 May 2006 12:04 AM

Sue Hoegemeier

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
<jbellnewspo***@hotmail.com> wrote:

Show quote

>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 that
>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
>>
>>