delete datastage jobs

srinivenigalla · Post by **srinivenigalla** » Mon Aug 06, 2007 9:19 am

Is there any command to delete jobs based on the status of the jobs in the project / folder

kcbland · Post by **kcbland** » Mon Aug 06, 2007 11:47 am

No. There's no API to delete jobs, the only approved method is via the clients.

dsexplorer · Post by **dsexplorer** » Thu Mar 08, 2012 10:51 am

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

chulett · Post by **chulett** » Thu Mar 08, 2012 1:14 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 08, 2012 3:38 pm

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>>';