MailNotification other than jobstatus 1

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
Poornagirija
Participant
Posts: 65
Joined: Fri Nov 19, 2004 12:00 am

MailNotification other than jobstatus 1

Post by Poornagirija »

HI folks, :D
We are working on DS7.5.1 on IMB AIX.
We have Master sequencer which is sheduled to run on daily basis.

Currently in our design we are using notification stage.

In the notification we are adopting the trigger failed.

Its working promptly and we are receiving mail when the job status = 3(ABORTED)

We want to enhance some more in this notification.

Suppose if i want to sent a mail notification for status other than 1(including 2 and 3)how to do these?

What is the exact functionality of attachements in Mailnotification stage?

Many thanks in advance
With Regards,
Poornagirija.

"Don't limit your challenges - challenge your limits"
loveojha2
Participant
Posts: 362
Joined: Thu May 26, 2005 12:59 am

Post by loveojha2 »

Use the following trigger condition

Code: Select all

JobActivityName.$JobStatus <>1
(Custom)

This should work fine.
Success consists of getting up just one more time than you fall.
Poornagirija
Participant
Posts: 65
Joined: Fri Nov 19, 2004 12:00 am

Post by Poornagirija »

HI LOVE,
Thanks for immediate reply.
I tried the code and its working fine for me. :D

Thanks a lot
With Regards,
Poornagirija.

"Don't limit your challenges - challenge your limits"
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Prefer DataStage constants, in case "they" change the values.

Code: Select all

JobActivityName.$JobStatus <> DSJS.RUNOK
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Knew that one was coming. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

ray.wurlod wrote:Prefer DataStage constants, in case "they" change the values.

Code: Select all

JobActivityName.$JobStatus <> DSJS.RUNOK
Is it going to be different in Hawk :?

-Kumar
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

That part is not.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply