Email Notification

beanieb · Post by **beanieb** » Thu Mar 13, 2003 1:32 am

How do I send a email notification attached wif a text file, which say, contains the job/error log, in DataStage on unix? Bcos the fields in the notification page of the notification activity doesn't include one to attach file.

If I have to use the 'mailx' command in unix, how do i send the file attachment?

Thanks

mihai · Post by **mihai** » Thu Mar 13, 2003 4:55 am

Without being able to test this proposed solution, I can't sure I'm 100% on it.

I'd look into building a script from DataStage, detailing the file to attach and so on, then invoking the mailer with the script as a parameter.

Kind regards,
Mihai

_________________________
desk direct:+441908448571

chulett · Post by **chulett** » Thu Mar 13, 2003 6:31 am

There are routines to extract information from the DataStage logs, off the top of my head I don't recall their names but they should be easy to look up. You can use them to get information out into a text file, but you'll probably have to code it up in Basic.

On sending mail, we occasionally use 'sendmail' but typically use something called 'mutt'. Mutt is a great little piece of GNU freeware (available from www.mutt.org) which, among other things, allows you to either attach files to or insert files into your email. You write a script to call mutt (or whatever) and then pass in whatever parameters are needed, including the filename to attach/insert. We do this in the controlling Batch after completion of the job and the log extracts.

Sorry, we don't use the Sequencer thingy so can't help you there.

-craig

chinek · Post by **chinek** » Thu Mar 13, 2003 10:00 pm

Hi

you can use the dsjob command to extract from the Data Stage logs and send that through email. Some scripting is required.

I have developed a package that will monitor the jobs,populate the statistics like nbr of records loaded etc, check on the sqlldr messages,check for oracle messages,send notification and much more.
In a nutshell it is designed to free up having an operator monitor the jobs and allow managers to see what is happening asap. If you are interested please email me at
nick.chuah@txu.com.au
The package is still under beta testing but should be ready for release in 2 weeks time.

Nick

ray.wurlod · Post by **ray.wurlod** » Thu Mar 13, 2003 10:37 pm

There are several sites at which I have worked that employ a similar scheme. Yes, it does require a small amount of scripting. Once.
Remember that DataStage can do ANYTHING for which there exists a command line interface, simply by starting it through DSExecute().
One site even sends SMS messages.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518