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
can we use job parameters in email notification body?
Moderators: chulett, rschirm, roy
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
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