View job log in batch job

[ping]

Have a batch job that calls say 4 jobs( job1,job2,job3,job4)

Then a sequence job will call this batch job first then send out email notification.

However in the email, it does not show the log for the individual jobs (job1,job2,job3,job4, like how many rows have been moved).

If in the sequence job, I run the job1,job2,job3,job4 then the notification, the email body does show me the log I wanted.

How can I make the sequence with the batch job send email showing logs at the individual job level?

Thanks,

Ping

[ray.wurlod]

You will need to create a custom routine to build the full message body that you've specified, which can then invoke DSSendMail to send the email. The Notification Activity is quite limited - indeed it's just a fancy front end to the DSSendMail function; replace the Notification Activity with a Routine Activity that invokes your routine. You will need to pass sender, recipient, subject, server and anything else you need as arguments to the routine.