How to remove many DataStage jobs automatically?

ArndW · Post by **ArndW** » Mon Jun 15, 2015 12:11 pm

Do you have a list of job numbers in a file that you can start with?

Also, the "DELETE VOC xxxx" is not correct, you would want to "DELETE.FILE xxxx" for the files, and then just the record from DS_JOBS.

I can't check now, but I think that one of the builtin menu items will remove associated files if the DS_JOB job name entry is missing, so you might just have to edit the DS_JOBS file.

Note that playing directly with this file, or any other VOC items, is dangerous and one or more backups prior to starting are to be recommended.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 15, 2015 6:20 pm

In addition to what Arnd suggested, remember that stages, links, containers and annotations are stored in DS_JOBOBJECTS, so you need to delete entries from that table, ideally before removing the entry from DS_JOBS.

I haven't tried this but, knowing that you can delete a job in Director client, can you delete multi-selected jobs using Director?

ArndW · Post by **ArndW** » Tue Jun 16, 2015 7:45 am

Is it about 1,111 jobs out of a total of 1,150 jobs? Both Ray and I think that it can be fast and efficient to select the jobs to delete in the director or to use the search functionality in the designer to get a list of jobs and then merely hit the DELETE button and go home while the jobs are deleted.

Since the manual deletion of jobs involves several files and tables it is prone to errors and should be avoided if at all possible.

ArndW · Post by **ArndW** » Tue Jun 16, 2015 9:05 am

Can you select the 250 valid jobs using dssearch or other means in the designer? If so, export them, delete everything in the project, then re-import the jobs.

joycerecacho · Post by **joycerecacho** » Tue Jun 16, 2015 11:46 am

I have a list of these 250 jobs, manually generated. Only a list, no .dsx.
There is no name 'pattern' I can use to identify them. As it was mentioned, I made a list based on the main job Sequences, manually.

Thanks in advance,

ray.wurlod · Post by **ray.wurlod** » Tue Jun 16, 2015 4:28 pm

You could script the exports that Arnd mentioned, backup the entire project, then delete and re-create the projects and import from the exported jobs.

ArndW · Post by **ArndW** » Wed Jun 17, 2015 1:46 am

With your list, you could export your jobs (dscmdexport) and then clean up the project before re-importing or create a new project with just the exported jobs in it.