cancel
Showing results for 
Search instead for 
Did you mean: 

Find process by schedule

sivavijayakumar
Level 2
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
------------------------------
1 BEST ANSWER

Best Answers

tejas99
MVP
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
------------------------------
If I was of assistance, please vote for it to be the "Best Answer". Thanks & Regards, Tejaskumar Darji - https://www.linkedin.com/in/tejaskumardarji/ Technical Lead

View answer in original post

2 REPLIES 2

tejas99
MVP
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
------------------------------
If I was of assistance, please vote for it to be the "Best Answer". Thanks & Regards, Tejaskumar Darji - https://www.linkedin.com/in/tejaskumardarji/ Technical Lead

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