topic Batch Job mail trigger in Application Development and Automation Discussions

Batch Job mail trigger

former_member221486 — Tue, 14 Jul 2015 06:08:14 GMT

Hello Experts,

I want to create small functionality where all batch jobs failed get notify by Mail trigger.

Suppose daily batch jobs getting failed then instead of checking manually automated mail should get trigger to respective mail Id's .

Please give ur suggestions or help .

Thanks in advance.

Best Regards,

Chaitanya Duvedi

Re: Batch Job mail trigger

deepan_v_s — Tue, 14 Jul 2015 06:14:44 GMT

Hello Chaithanya,

Please check this SCN post which will help,

Regards,

Deepan Swaminathan.

Re: Batch Job mail trigger

former_member221486 — Thu, 16 Jul 2015 11:34:07 GMT

Is there any user exit or enhancement possible?

Re: Batch Job mail trigger

Former Member — Thu, 16 Jul 2015 11:43:39 GMT

Hello Chaitanya,

Can you please explain what "user exit or enhancement" are you looking for?

Regards,

Bala

Re: Batch Job mail trigger

AntonFarenyk — Thu, 16 Jul 2015 14:00:49 GMT

Hello

I use table TBTCO and SQ01 infoset query for this purpose. I monitor failed jobs daily with a report turning once a day in background. It’s been very reliable for last 3-4 years.

Create Infoset with SQ02 on table TBTCO. In SQ01 select by Planned start date and State of job = A. Create a variant with dynamic date calculation. Schedule daily i.e. just before midnight to get complete picture of the day. When scheduling it in background under spool recipient button specify distribution list with needed e-mail.

Regards,