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
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.