Need to change text of notification after scheduled DTS job runs

[mp9]

Hello.

I have a DTS job that pumps out a delimited text file. It's scheduled to run once a month and that works fine. I've edited the Job to use notifications, so that an email address gets notified that the job has completed, either successfully or unsuccessfully. Is there any way to append additional text to the default notification messages that get sent?

Am using SQL Server 2000.

 

[mutley1]

As far as I know, not to the actual job error message, but there are a few other things you could do. It depends on what additional text you want to send - fixed text or dynamic as per the time the job has run?

You could do 1 of 2 things:

1. Add a step in the DTS package to mail something on completion or on failure, or
2. Create a custom alert and add that as a step in the job that runs the DTS (using raise error).

M.