Hi VTA,
If you want to send the results in one e-mail then you must accumulate the results in a string global variable and then use that in the body of the e-mail. If there are a larger number of results then I'd suggest outputting the results into a text file and attaching that to the e-mail.
What you have done is an Iterate on each row - this job actually doesn't do anything, so you'll need:
- create a string context variable (results)
- design your job like:
tOracleInput_1 --row1--> tJavaRow
|
|
on Subjob OK
|
|
v
tSendMail
In the tJavaRow:
context.results = context.results + "\n" + row1.result;
In the tSendMail, body
context.results
I don't even understand what's the meaning of:
- row > main
- trigger > onSubJobOk
- trigger > obComponentOk |
If you don't know what these terms mean then you are going to have great difficulty in designing effective jobs. I would suggest you read section "4.4 Connecting components together" on page 62 of the User Guide.
Cheers,
c0utta
