Skip to Content
avatar image
Former Member

T-Code to stop all the Process chains

Hi All,

We have ECC upgrade.During cut over activites, we need to un schedule all the process chains in BW.

Is there any T-Code to unschedule all the process chains and reschedule all the PCs after upgrade??

Thanks in advance.

Best Regards,

Krishna.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • Best Answer
    Dec 23, 2014 at 08:52 AM

    Hi Krishna,

    The t/code that pops up in my mind is RSPCM. I don't know if you are using this for daily monitoring but if yes, it can help you to unschedule and reschedule the Process Chains. Another useful t/code is SM37.

    However, in my experience simply unscheduling and rescheduling Process Chains is not enough. E.g. you will also have to consider delta queues in the ECC source system. Usually all deltas will have to be fetched prior to the upgrade. It's important to make a runbook to document the timelines and actions to be executed by the various people or teams.

    Best regards,

    Sander

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Krishna,

      Maybe I did not formulate my suggested approach clear enough. If that is the case, then I am sorry about that.

      You should not delete any jobs because then you will loose them and the purpose was to cancel the jobs. You can find that option in the menu of SM37. It changes the status from "released" to "scheduled". The job will remain in the system but with status "scheduled" it will never run (only jobs with status "released" can run). After the upgrade you can easily release them on another date w/o a need to change anything else.

      If you deleted the jobs, then you have to find another way of rescheduling them. I see two options:

      • If there is in SM37 like overview (via context menu of Process Chain Starter) any other job with status "finished", then you can copy it, change the scheduling parameters according to your needs (incl. periodicity) and release it;
      • Alternatively, you can maintain the scheduling parameters in the Process Chain Starter variant itself, and after that activate the Process Chain. This will also release a background job which you can find back in the SM37 like overview I mentioned before.

      Best regards,

      Sander

  • Jan 12, 2015 at 02:02 PM

    Hi,

    I think you should take help of basis team.

    Besides this,As i know there is one program BTCTRNS1 to suspend all the scheduled jobs and other program BTCTRNS2 to reschedule the jobs.

    Hope it will help.

    Regards,

    Swapna

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 23, 2014 at 09:06 AM

    HI Krishna,

    Go to sm37  and enter the job name BI_PROCESS_TRIGGER .Find out all the job under this name and delete the job from the database.

    once the upgrade has been completed activate and schedule the each and every process chain.

    Regards,

    Sakthivel S

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 23, 2014 at 09:09 AM

    Hi,

    there is no tcode for the scheduling or un scheduling the PC.

    you can do manually or through ABAP program. you can check the tcode - RSPCM and RSPC1,RSPC

    you need to check the some tables - RSPCCHAIN,RSPCPROCESSCHAIN.

    after completing the chain you can check with the SM37 - job overview.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 23, 2014 at 09:19 AM

    Hello Krishna ..............

    there is no specific  tcode for the scheduling or un scheduling in process chain.

    you can do manually or through ABAP program. you can check the  process chain using tcode -

    RSPCM and RSPC1,RSPC

    and also check the some tables - RSPCCHAIN,RSPCPROCESSCHAIN.

    after completing the chain you can check with the SM37 - job overview.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 23, 2014 at 09:22 AM

    Hi,

    Please gotrw the link below-

    Unconventional way of Dealing with Jobs during Upgrades with the help of programs

    The program mentioned in the link will deschedule all the PC's However if your downtime is for 6 hours then you might have to remove few of your process chains fro schedule. You can remove them manually or from program. Check it as per your requirement.

    Hope this helps,

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 23, 2014 at 03:31 PM

    Hi Krishna,

    You can use following standard programs to un-schedule/schedule.

    Goto SE38

    To Schedule : BTCTRNS1 --> Be careful - It does not have any further selection screen, once you press Execute or F8 all process will suspend.

    To Un-Scdedule: BTCTRNS2 - --> Be careful - It does not have any further selection screen, once you press Execute or F8 all process will schedule.

    Thank you,

    Nanda

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 16, 2015 at 09:45 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 16, 2015 at 11:09 AM

    Hi,

    During ECC upgrade you have to clear all Delta queue entry and SMQ1 entry.Otherwise if it is deleted by BASIS during upgrade and you end up with loss of records in BW.

    Regarding Stopping all PC, there is no TCODE.You can Keep the PC in Hold till upgrade by contacting Scheduling Team including V1,V2,V3 jobs also should be on Hold.

    After Upgrade make sure all deltas running Fine..

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 16, 2015 at 02:07 PM

    Hi Krishna,

    If the process chain is already started then you can use REMOVE
    FROM SCHEDULE to stop it.

    But as you said it is during cut over activities so please make
    changes in Maintain start process selecting an exact date you want to start from

    Thanks,

    Satish


    pic_4.PNG (27.6 kB)
    Add comment
    10|10000 characters needed characters exceeded