delete datastage jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Thu Aug 11, 2005 5:21 pm
delete datastage jobs
Is there any command to delete jobs based on the status of the jobs in the project / folder
-
- Premium Member
- Posts: 23
- Joined: Wed Apr 16, 2008 5:34 am
- Location: Prague,Cz
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
http://publib.boulder.ibm.com/infocente ... layer.html
Regards
DSExplorer
DSExplorer
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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:
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>>';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.