Skip to Content

Aim: – In order to kill a Job which is designed using Business Objects Data Service by making use of a Script.

Benefit: – A Job which is running for a long period of time or has entered a buffer pool can be terminated by executing the Script, which will in turn allow the other jobs in the pipeline to get executed and would ensure error free and independent execution of the remaining Jobs at Business Objects Data Services

Steps:-

1) Create a Project say Prj_KillScript.

2) With in the Project create a Job say Job_Kill.

3) Within the scope of the Job_Kill create a Work Flow say WF_Kill.

4) Take a Script control within the work flow WF_Kill and name it as Sql_Kill.

5) Paste the below code at the Sql_Kill Script.

sql (‘PAR’,’delete from DI_BatchControl where Jobname=\’JOB_Running_Buffer\”);

Here ‘PAR’ is the schema.

DI_BatchControl is the table name where the Job execution details are stored.

JOB_Running_Buffer is the name of the Job which has entered the buffer pool while execution (Job running on for a long period of time)

6) Finally execute the Job – Job_kill.

Result: – The execution of the Job – Job_Kill will ensure that the long time running Job (JOB_Running_Buffer) is been deleted and now the other set of Jobs can be executed independently.

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Ragupathy Thirumoorthy

    Hi Ashish

    DI_BatchControl table name is correct? , i check in my schema i didn’t find.

    I am using BODS 4.0.  in my designer screen showing job is running. But job is already completed.

    thank’s

    Ragu

    (0) 
  2. Sandeep Jain

    Hello,

    1. You are saying that below funtion and its paramters will be constant for killing any Job using Scripts.

    sql (‘PAR’,’delete from DI_BatchControl where Jobname=\’JOB_Running_Buffer\”);

    2. This script can be executed at any time after the Job is trigerred. Because sometimes what happens, we close our designer and we are left with any option to kill that Job again.

    Pls confirm.

    (0) 
  3. Abhay Mhatre

    Hi Ashish,

    I am using the DataServices 4.0 SP2 and can’t find the table/view you mentioned to kill the job.

    Can you tell what version of DS you are using? Is there corresponding table/view in DS 4.0?

    Thanks,

    Abhay

    (0) 
  4. Scott Broadway

    This is NOT Data Services standard functionality, and you have provided no details on how to accomplish this in a supported manner. As such, I strongly recommend against others trying to implement this.

    (0) 

Leave a Reply