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
ketanshah123
Participant
Posts: 88 Joined: Wed Apr 05, 2006 1:04 am
Post
by ketanshah123 » Fri May 09, 2008 3:34 am
Hi
I want to send a mail notification if any job in Job Actvity in sequence ends with warnings. But I dont wants to use mail notification activity stage.So how can I do it ?Is it possible on Cstom trigger type in Job activity stage through some expression...
If yes then how can I check whether job ends with warning and then how can I send the mail
Thanx in advance
tsn
Participant
Posts: 51 Joined: Wed Jan 10, 2007 1:32 am
Post
by tsn » Fri May 09, 2008 3:47 am
Use job status to find out the job completed with warnings or not. then you use routine (DSSendMailTester) to send the mail.
with regards,
tsn
ketanshah123
Participant
Posts: 88 Joined: Wed Apr 05, 2006 1:04 am
Post
by ketanshah123 » Fri May 09, 2008 6:18 am
can you plz provide me the example of DSSendMailTester as I am getting syntax error again and again ...
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Fri May 09, 2008 6:50 am
how about telling us what your syntax error is, that might be easier.
ketanshah123
Participant
Posts: 88 Joined: Wed Apr 05, 2006 1:04 am
Post
by ketanshah123 » Fri May 09, 2008 6:57 am
just getting message general syntax error ...
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri May 09, 2008 7:18 am
Why the heck not just simply use the Notification Activity stage? The 'Tester' routine is just that - for
testing.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri May 09, 2008 4:05 pm
DSSendMailTester is provided precisely so that you can inspect the code and thereby learn the correct syntax for invoking DSSendMail().
Please do so.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
tsn
Participant
Posts: 51 Joined: Wed Jan 10, 2007 1:32 am
Post
by tsn » Mon May 12, 2008 1:40 am
have you figured it out?
with regards,
tsn