xp_sendmail killing Schedule Job  
Author Message
CrazyCalculator





PostPosted: Mon Feb 09 10:39:33 CST 2004 Top

SQL Server Developer >> xp_sendmail killing Schedule Job





all my best error trapping efforts have been in vain. Can anyone euggest some way to trap the errors coming back from xp_sendmail so that it doesn't kill the job

Thanks in advance!

---
Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community Website: http://www.hide-link.com/

SQL Server7  
 
 
Keith





PostPosted: Mon Feb 09 10:39:33 CST 2004 Top

SQL Server Developer >> xp_sendmail killing Schedule Job I don't know that it will be possible. Perhaps you need better =
cleanup/validation routines within the email addresses. Perhaps using a =
different method (such as xpsmtp) would allow you to use better error =
checking. Refer to http://sqldev.net/xp/xpsmtp.htm for more =
information.

--=20
Keith




> I'm using a Scheduled Job on SQL2000 to send Email Reminders to users. =
Essentially, on a specified date, the job runs and executes a stored =
procedure that gets together a list of email addresses and sends the =
reminder. I use a cursor to loop through the email addresses as each =
email is a little different. Everything works great, but if someone has =
a non-sensical email (something that makes it through the checks I'm =
already making on the emails) then the job fails. I've attemped to trap =

>=20

>=20
> all my best error trapping efforts have been in vain. Can anyone =
euggest some way to trap the errors coming back from xp_sendmail so that =
it doesn't kill the job.
>=20
> Thanks in advance!
>=20
> ---
> Posted using Wimdows.net NntpNews Component - Posted from SQL Servers =
Largest Community Website: http://www.sqlJunkies.com/newsgroups/