How to delete DataStage jobs at the command line

1.    Login to the DataStage Administrator. Select the Project and click the Command button. Then execute the following command:

LIST DS_JOBS <job_name>

2.    Go to the project directory and list all files with the job number returned from item 1.

On Unix/Linux execute,

"ls | grep <job_number>"

3.    On Windows use search in Windows Explorer or from command (DOS) prompt use

"dir *<job number>".

4.    This should output something like:

DS_TEMPnn, RT_BPnn, RT_BPnn.O, RT_CONFIGnn, RT_LOGnn, RT_STATUSnn, RT_SCnn

where nn is the job number.

5.    Delete all the files found in step 2.

On Unix/Linux

"rm -r <FileName>nn", e.g. "rm -r DS_TEMP51".

On Windows
Delete these from Windows Explorer or from command (DOS) prompt execute:

"del <FileName>nn", e.g. "del DS_TEMP51"

6.    In DataStage Administrator command window execute the commands below one by one:

 DELETE VOC DS_TEMPnn
DELETE VOC RT_BPnn
DELETE VOC RT_BPnn.O
DELETE VOC RT_CONFIGnn
DELETE VOC RT_LOGnn
DELETE VOC RT_STATUSnn
DELETE VOC RT_SCnn
DELETE DS_JOBS job_name