can we use job parameters in email notification body?

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
qutesanju
Participant
Posts: 373
Joined: Tue Aug 26, 2008 4:52 am

can we use job parameters in email notification body?

Post by qutesanju »

I have an input file and that writes in oracle table and I'm capcturing rejected records in a file.
Lets say there 5 reject files for 5 oracle tables
And I'm using email notification at the sequencer level (after all jobs ran) to send email notification to users

now my question is -is there any way to write all counts in email body?

E.g email body will be
Input file records : 100
Reject file 1 records : 10
Reject file 2 records : 0
Reject file 3 records : 0
Reject file 4 records : 50
Reject file 5 records : 5
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

This question has been asked and answered quite a bit here, an exact search for "email body" will answer your question.
-craig

"You can never have too many knives" -- Logan Nine Fingers
vamsi.4a6
Participant
Posts: 334
Joined: Sun Jan 22, 2012 7:06 am
Contact:

Post by vamsi.4a6 »

1)After creating reject files create one file body.txt which contains output

Input file records : 100
Reject file 1 records : 10
Reject file 2 records : 0
Reject file 3 records : 0
Reject file 4 records : 50
Reject file 5 records : 5

Use wc,loop and echo commands

2)Finally include below command in the script
mail -s "Mail subject" to@example.com < body.txt
Post Reply