List of Scheduled Process Chains in SAP BW
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
3. Click the button to go to Step OveriewSELECT ajobname ajobcount asdlstrtdt asdlstrttm bprogname bvariant
INTO CORRESPONDING FIELDS OF TABLE l_t_scheduled
FROM tbtco AS a JOIN tbtcp AS b
ON ajobname = bjobname AND
ajobcount = bjobcount
WHERE ajobname = ‘BI_PROCESS_TRIGGER’ AND<br /> astatus = ‘S’. “Scheduled