Delete jobs/categories from commanline

mjgmc · Post by **mjgmc** » Tue Apr 29, 2008 6:47 am

Is it possible to delete jobs or categories from the command line?

How?

ArndW · Post by **ArndW** » Tue Apr 29, 2008 7:00 am

No, deletion of jobs and categories can only be done through the clients.

mjgmc · Post by **mjgmc** » Tue Apr 29, 2008 7:02 am

thanks

alanwoo · Post by **alanwoo** » Wed May 28, 2008 6:39 pm

What's the fastest way to delete jobs?
Especially when you keep getting '<job>' is referenced by another component and you press Yes to All and you keep getting the message popping up...

ray.wurlod · Post by **ray.wurlod** » Wed May 28, 2008 7:56 pm

Welcome aboard.

Speed is not the issue here. Being systematic and accurate is. DataStage needs to check that you really want to delete the job even though other jobs (and, perhaps, routines) might depend on it.

If you want to be totally arrogant you can disable these confirmations. But let me state that, in over 12 years working with DataStage, I have never done so.

alanwoo · Post by **alanwoo** » Wed May 28, 2008 9:09 pm

unfortunately didn't get to see your whole post because i'm not a premium account user. only saw
"Welcome aboard. Speed is not the issue here. Being systematic and accurate is. DataStage needs to check that you really want to delete the job even though other jobs (and, perhaps, routines) mi ..."

will probably have to sign up. I understand the important of accuracy but when your on a large DS project (probably one of the biggest in Australia), it can be a very time consuming process. Just deleting a folder of jobs takes like a very long time and what makes it longer is when I have to keep clicking on these popus. It would be nice if I could just run a script and spent my time on other stuff without monitoring this. Like compiling for example, using a script takes 1 hour, if using DS manager takes a day.

ag_ram · Post by **ag_ram** » Sat May 31, 2008 4:09 pm

ArndW wrote:No, deletion of jobs and categories can only be done through the clients.

Can't we do it from the Server as -

1. Opening the DataStage Shell(dssh) of the Project
2. Executing the following query

Code: Select all

DELETE FROM DS_JOBS WHERE NAME="%<JobName>"

ray.wurlod · Post by **ray.wurlod** » Sat May 31, 2008 4:29 pm

No.

That would certainly cripple the job, but would not delete it.

There are many other entries for a job, including in DS_JOBOBJECTS, VOC and all the job-specific repository tables DS_TEMPnnn and RT_*nnn and their corresponding file dictionaries, not to mention dependencies that might be recorded in other jobs.

Deletion via the clients manages all these (except the last).

zhoum00 · Post by **zhoum00** » Tue Aug 12, 2008 9:00 am

Hi Ray, you're talking about disabling confirmation for massive delete. How could I do that?

Thanks!

chulett · Post by **chulett** » Tue Aug 12, 2008 9:19 am

It's an option in the Manager. And off is off, single deletes or 'massive' ones.