List of Scheduled Process Chains in SAP BW

[Former Member]

Overview

In SAP BW, there is no simple and straight forward way to get a list of scheduled Process chains. The program discussed in this blog will give you a list of scheduled process chains and their respective schedule start date and time.

h5. Laborious way

Let us look at the lengthy process to get the name, date and time for each process chain job you find in SM37.

1. In SM37, find jobs with job name 'BI_PROCESS_TRIGGER' and Job status 'Released'

2. Double click on a job to see job details that contain scheduled date and time

!https://weblogs.sdn.sap.com/weblogs/images/52637/JobDetails.png|alt=image|src=https://weblogs.sdn.sa...!

3. Click the button to go to Step OveriewSELECT a_{jobname a}jobcount a_{sdlstrtdt a}sdlstrttm b_{progname b}variant
INTO CORRESPONDING FIELDS OF TABLE l_t_scheduled
   FROM tbtco AS a JOIN tbtcp AS b
              ON a_{jobname = b}jobname AND
                 a_{jobcount = b}jobcount
WHERE a_{jobname = 'BI_PROCESS_TRIGGER' AND<br />      a}status = 'S'. "Scheduled