Batch Job mail trigger

[former_member221486]

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

[deepan_v_s]

Hello Chaithanya,

Please check this SCN post which will help,

Regards,

Deepan Swaminathan.

[former_member221486]

Is there any user exit or enhancement possible?

[Former Member]

Hello Chaitanya,

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

Regards,

Bala

[AntonFarenyk]

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,