Email Notification Activity

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
atulgoel
Participant
Posts: 84
Joined: Tue Feb 03, 2009 1:09 am
Location: Bangalore, India

Email Notification Activity

Post by atulgoel »

Hi,

I wanr to send email if any job fails in my sequencer with the job name and log in my email.

Please let me know how can i implement this.

Thanks
Atul
Atul
cipsy
Participant
Posts: 14
Joined: Wed May 02, 2007 4:59 am

Re: Email Notification Activity

Post by cipsy »

Hi

You can use Notification Activity and can use job status and job name ( click to ... and see external paramater). But i thinl you cant attached job log.
atulgoel
Participant
Posts: 84
Joined: Tue Feb 03, 2009 1:09 am
Location: Bangalore, India

Post by atulgoel »

I have 5 Job Activity in my sequencer.

How can I pass the a particular job name which has aborted to Notification Acitvity?
Atul
cipsy
Participant
Posts: 14
Joined: Wed May 02, 2007 4:59 am

Post by cipsy »

All job goes to sequencer stage. And sequencer stage goes Notification activity stage.
bhasds
Participant
Posts: 79
Joined: Thu May 27, 2010 1:49 am

Post by bhasds »

Hi Cipsy,

You can keep a User Variable activity in between the Sequnecer and the Notification activity.

In Uservaribale activity-

Jobname

Code: Select all

If Job_Activity1.$JobStatus =3 Then    Job_Activity1.$JobName Else If Job_Activity2.$JobStatus =3 Then Job_Activity2.$JobName Else If  Job_Activity3.$JobStatus=3 Then Job_Activity2.$JobName Else If Job_Activity4.$JobStatus=3 Else Job_Activity4.$JobName If Job_Activity5.$JobStatus=3 Then Job_Activity5.$Name Else "All Jobs has finished successfully"
In Notification Activity-
In Email Subject call the Uservariable i.e. Jobaneme through External Parameter Helper.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Or simply enable the "Include job status in email" property in the stage.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply