Page 1 of 1

Deleting jobs in bulk

Posted: Wed Apr 22, 2015 1:58 pm
by attu
Hi,
We have a very large project where we have identified obsolete jobs ( ~6 to 7 k) .. What is the best approach to delete all those obsolete jobs ?


I would prefer deletion via istool and script it. Currently waiting on a patch for istool.

Appreciate feedback from DS users,

Thanks

Posted: Wed Apr 22, 2015 2:31 pm
by chulett
Wondering... 6 or 7 thousand out of how many?

Posted: Thu Apr 23, 2015 9:08 am
by qt_ky
One option is using Director, View menu, uncheck Show Folders, wait for full jobs list to display at once, click a column header such as 'Last ran' to sort by last run time. Assuming you want to delete jobs that haven't run in a long time, multiple select them using Shift or Ctrl and hit the delete key.

Posted: Thu Apr 23, 2015 9:47 am
by chulett
If you do that, make sure you turn off the automatic refresh!

Posted: Thu Apr 23, 2015 7:22 pm
by attu
Thanks for the replies. I already tired that, there are too many jobs (15k) and Director takes for ever to load the jobs.

Posted: Fri Apr 24, 2015 5:34 am
by qt_ky
Yes, it would not be fast, but once you do it, it would be faster each time. It's not like you have to sit and wait for it. Just open it up and check back later.

I thought projects had a physical limit of around 5K jobs, so I am surprised you have 15K in a single project.

Hopefully you already have a full project backup, such as a dsx or isx file. An alternative is to edit your backup and import only what you want to keep into a new project, then delete the old project.

Posted: Fri Apr 24, 2015 6:48 am
by chulett
That limit is O/S dependent, from what I recall.

And I counsel... patience.

Posted: Mon Apr 27, 2015 1:13 pm
by electajay
I think there is limit on number of directories or files that you can create under project directory. Once that limit is reached you can not create or edit or open any jobs. we more than 10K jobs in a project.