Thanks to everyone for your input. I'm glad there are alternatives out there for these xp_sendmail problems that seem to be so prevalent.

DrNetwork: Can you elaborate on your code?...

Can't you just write a query to a bogus table to make the step fail? We have a job that we intentionally want to fail so that we get...

Thank you very much. It's exactly what I was looking for!

No particular topic. I'm a system DBA. In trying to get our applications converted to SQL2000, one of the application DBAs asked for a list of differences. ...

Thanks Simon. That's helpful. Unfortunately it is going to be difficult to get the 100s of application developers to change the apps which access our databases.

But maybe we...

Thanks David. But I'm not sure what you mean by add "APP=text to your SQL connection." I'm a system DBA and not an application DBA. Does this...