Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-04 : 07:11:53
|
| DB writes "I have a job with multiple steps (up to 60). Some steps fail because the raw data files contain IDs that are not in the database. That is all good so. It works well. The job runs, fails and exists. I have setup an operator (me) and am alerted after the failure. But the message is too standard. Can I have the message include more debugging info, such as:Executed as user: SQL\SQLAdmin. INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_tblNVSONActivities_tblIDsNVSActivities'. The conflict occurred in database 'research', table 'tblIDsNVSActivities', column 'ID'. [SQLSTATE 23000] (Error 547) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.I get that message if I run the Stored Proc on itself. How do I get this emailed to me automatically?" |
|
|
|
|
|
Emailing error report after running SQL 2K job