Skip to Content
Author's profile photo Former Member

List of Scheduled Process Chains in SAP BW

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.sap.com/weblogs/images/52637/JobDetails.png|border=0!

 

3. Click the image 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

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Hi there,

      at least in BI7 you have the transaction RSM37 which does pretty much the same.

      Author's profile photo Former Member
      Former Member
      Blog Post Author
      Hi Stefan,
      Thanks for your comment and details. After looking at RSM37, I agree that it is a better way of getting this information. I am also not sure if RSM37 is available in 3.X.

      Thanks,
      Uday

      Author's profile photo Shanthi Bhaskar
      Shanthi Bhaskar
      Hi Stefen,

      Awesome tcode. Thanks for sharing...

      Author's profile photo Former Member
      Former Member
      Hi,

      Another alternative could be to use SAP Central Process Scheduling (CPS).
      CPS allows you not only to run regular SAP jobs and process chains in all your SAP systems, but it can also monitor SM36/37 jobs and BI process chains that are not started by CPS at all.
      For BI chains, it will automatically show all processes of the same chain in a hierarchy to indicate what belongs together.
      Especially if you need to monitor multiple SAP systems, or multiple types of jobs at the same time, this can be very helpful.

      Regards,

      Anton.

      Author's profile photo Former Member
      Former Member
      Another alternative we use,
      We maintain all our process chains in RSPCM. This would let us know when a process chain last ran
      Author's profile photo Jim Spath
      Jim Spath
      We use an enterprise scheduler (CA AutoSys) to start process chains, so already know when they start (or are supposed to start), when they fail, and how long they run.

      What has been challenging to view are how many are running at any one time.  I put together a slightly flawed graphic with data pulled from the same place that ST03 displays.  I posted that logic on the SCN wiki code snippets area: Analyzing BW Process Chain Run Times.  Surprisingly, this worked in 3.5 and in 7.0.

      Jim

      Author's profile photo Surendra Kumar Reddy Koduru
      Surendra Kumar Reddy Koduru
      Hi,
      Good one and very much usefull.

      Thanks
      Surendra Reddy