topic Find process by schedule in University Forum

Find process by schedule

sivavijayakumar — Mon, 28 Nov 2022 12:37:00 GMT

Hello Team,

I am using bpaschedule table and bpascheduletrigger table to get schedule information. I am not able to fetch the process which is attached to the schedule.

I need the table name where I can find the process id for the specific schedule.

Kindly let me know if somebody knows the answer.

------------------------------
siva vijayakumar
------------------------------

RE: Find process by schedule

Tejaskumar_Darji — Mon, 28 Nov 2022 14:05:00 GMT

Hello Vijay,

Please look at the tables below for the same,

1) BPATask - Get the ID column from here from schedule name
2) BPATaskSession - use ID from step1 here as taskid to get processid
3) BPAProcess - use processid here to get the process name

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

RE: Find process by schedule

sivavijayakumar — Mon, 28 Nov 2022 17:00:00 GMT

Hello Darji,

Thank you for your quick response. I can able to get process information by following your response on the above thread.

Once again thank you very much 🙂

------------------------------
siva vijayakumar
------------------------------