Page 1 of 1
delete datastage jobs
Posted: Mon Aug 06, 2007 9:19 am
by srinivenigalla
Is there any command to delete jobs based on the status of the jobs in the project / folder
Posted: Mon Aug 06, 2007 11:47 am
by kcbland
No. There's no API to delete jobs, the only approved method is via the clients.
Posted: Thu Mar 08, 2012 10:51 am
by dsexplorer
Below presentation describes
how to manually delete a DataStage job for all versions of Information Server DataStage.
http://publib.boulder.ibm.com/infocente ... layer.html
Posted: Thu Mar 08, 2012 1:14 pm
by chulett
And you'll note that the first thing it says is that it is only for those circumstances when you can no longer do it from the client.
Posted: Thu Mar 08, 2012 3:38 pm
by ray.wurlod
Their approach to the local repository leaves a heap of orphan entries in DS_JOBOBJECTS.
You still need to delete all the job's RT_ entries and DS_TEMPnnn table, so you still need to know the job number before deleting the job entry from DS_JOBS.
I prefer the following approach, using DataStage SQL:
Code: Select all
DELETE FROM DS_JOBOBJECTS WHERE OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job name>>');
DELETE FROM DS_JOBS WHERE NAME = '<<Job name>>';