Warning messages to be sent as a email

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsquestion
Participant
Posts: 26
Joined: Thu Feb 03, 2005 1:05 am

Warning messages to be sent as a email

Post by dsquestion »

Hi all,

I have a client requirement as followed when the job gets aborted the warning or fatal message in the log file has to be sent as an email through DS email notification activity. Is there any DS functions or I need to write a routine.

Please do help me.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
your issue can be devided into 2 seperate topics:
1. getting the warnings/errors or what ever.
2. sending a mail notification.

both were covered extensively in the past (use search in this forum).

In short:
1. you can:
- get the warnings from the logs using routines like DSGetJobInfo(...) and the likes of it (all documented in your help)
- make a job report with similar routines or the dsjob command line interface.

2. - use the GUI mail notification in a sequence job
- use the existing (perhaps you'll want to adjust it to your needs) routines under the Routines > built-in > utilities for sending E-mails.

By the way being able to send mails depends on the ability to do so on the server you have DS installed on (i.e. in unix having sendmail work )

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Unless your requirements are more complicated than you've listed, that's as simple as enabling the Include job status in email option in the Notification Activity stage.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

As for abort, they will be the one in the top as they will be the last job run before failure.
Post Reply