June 23, 2003 at 4:19 pm
Hi!
Following is an excerpt from a sql server site...
DTS Packages and Alerts:
If you want to be notified if a DTS package fails, you should configure it to write an event to the application log on completion, and configure an alert.
In the DTS properties, enable the Write completion status to event log option on the Logging tab. Then define an alert that will fire when a specific error is logged, define yourself as an operator, and specify what message should be sent.
Here's the problem:
How do U go about setting up the alert??? I have been trying for a one whole day and I'm running out of clues!!
Can somebody help me on this??
Cheers
Anupam
June 25, 2003 at 2:57 pm
I am not familiar with alerts. But I do have a notification system for our DTS packages.
I simply schedule each package and then go to the job that executes the DTS package and tell it on failure to notify a specific operator and I get those messages when there is a failure.
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
June 25, 2003 at 3:28 pm
Thanx rmarda. I know it can be done by scheduling the DTS package and then U can get the job that runs the package to notify in case of failure. I was just wanting to see whether I could do the task in another way. Thanx again 🙂
anupam
June 25, 2003 at 11:01 pm
See BOL - SendMailTask object, then click on example.
I haven't tried it yet. Your post got me thinking about this, so I started looking for a way. It's now on my to-do-list to try it.
Bill
June 27, 2003 at 12:00 pm
Here is an Article By Joseph Sack on Trapping DTS Errors
http://www.joesack.com/DTSErrorTrap.htm
Shas3
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply