Find process by schedule

[sivavijayakumar]

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
------------------------------

[Tejaskumar_Darji · Accepted solution]

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
------------------------------

[sivavijayakumar]

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
------------------------------