One of my users accidentally set off a recurring job that created over 40,000 executions. I'm trying to deactivate these executions.
Is there a way to deactivate a large number of executions, without having to do it 5000 at a time?
1) use the filter and export function from the activity window to create a list of run numbers (multiple files for your number of tasks)
2) create a script object that contains the following statements (2 * cancel deactivates an object)
:set &xyz = cancel_uc_object (&runnr):set &xyz = cancel_uc_object (&runnr)
Another way is to contact support and ask for an SQL statement - but this requires native access to the database
As Peter mentioned already this case can solved by automic Support in the best way, deleting it manually or with an script option is a good way if you have a handful of objects to deactivate, but 40.000 are way too much to deactivate manually or via script.
Please open an incident at Support (either via E-Mail or webinterface and add following info to it):
what Version of Automic are you running on (8.00A, 9.00A V10)
what DB do you use (MSSQL, Oracle, DB2)
is there any similarity with that objects (same name, same activator runnumber) this helps us to assemble the Statements to your specific system.
please also always note that deleting activities by using a SQL script is not a solution to use daily, it is okay for an emergency like this, but doing it often via SQL Statement will make the reports and statistics in your system pointing to wrong or edited Information which might not be good for Revision or Archieving.
Harald Heidinger, Automation Specialist.
Retrieving data ...