Process Chain Start time in job Completion Mail Notification

[former_member546611]

Hello,

We have process chain scheduled which on completion, mails are triggered notifying the completion.

How can we add the start time of the job which was completed?

Eg: A job starts at 9:00 Am and it completes at 11:00 AM - So around 11:05 AM , a completion mail notification is sent to users. but how can we add the data that this job was started at 9:00 AM

Thanks,

Hetal

[former_member600441]

Dear hetalkat,

You can achieve the requirement via Custom ABAP SE38 Program. Below link will guide you further.
https://blogs.sap.com/2019/10/11/object-oriented-way-of-sending-an-email-from-abap-side./

RSPCPROCESSLOG table holds the process chain logs information in SAP BW.

This program you can add in Process chain step which will trigger mail upon completion.

Regards,
Pradeep Jaiswar

[former_member546611]

Thanks Pradeep for your inputs. The mail is generated post the process chain is completed. But the mail does not include the information of the start time of the process chain for which the mail is sent on completion. Can we add this input in the mail body as well?

Thanks.

Regards,

Hetal

[former_member600441]

Dear Hetal,

Yes you can add the start timing in the body of the content.

Below is the example code you can try adding in the abap report.

Select single batch_time into Data(lv_trigger_time) from rspcprocesslog where variant = 'ZPC_XXXX' and type = 'TRIGGER' and batch_date = sy-datum. ls_soli-line = 'Dear Team ,<P>'Process Chain- ZPC_XXXX is started at' && lv_trigger_time && '</P>'. APPEND ls_soli TO lt_soli.|

Regards,
Pradeep Jaiswar