Page 1 of 1
Delete jobs/categories from commanline
Posted: Tue Apr 29, 2008 6:47 am
by mjgmc
Is it possible to delete jobs or categories from the command line?
How?
Posted: Tue Apr 29, 2008 7:00 am
by ArndW
No, deletion of jobs and categories can only be done through the clients.
Posted: Tue Apr 29, 2008 7:02 am
by mjgmc
thanks
Posted: Wed May 28, 2008 6:39 pm
by alanwoo
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...
Posted: Wed May 28, 2008 7:56 pm
by ray.wurlod
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.
Posted: Wed May 28, 2008 9:09 pm
by alanwoo
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.
Posted: Sat May 31, 2008 4:09 pm
by ag_ram
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>"
Posted: Sat May 31, 2008 4:29 pm
by ray.wurlod
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).
Posted: Tue Aug 12, 2008 9:00 am
by zhoum00
Hi Ray, you're talking about disabling confirmation for massive delete. How could I do that?
Thanks!
Posted: Tue Aug 12, 2008 9:19 am
by chulett
It's an option in the Manager. And off is off, single deletes or 'massive' ones.