I have JOBP that is in Preparing status few thousands times. I choice cancel (recursive) but it take a very long time to clear executions? Is there a faster way to kill this process? This JOBP will be deleted.
Could you tell the exact name of the job scheduling manager? You can choose it from the categories list. This will help the right people to see your question and provide input.
I use AWA. Automation Engine API 12.1.0+build.9426 and choice CA Workload Automation in categories list. I hope that was good choice?
As this is currently posted in the CA Workload Automation space and you had mention that you are using AWA / Automation Engine v12.1 I will move this discussion thread over to the CA Automic Workload Automation section to better reach the product audience.
To the best of my knowledge, if a workflow is stuck in Preparing status, it is not possible to to cancel it using the normal Cancel or Cancel (recursive) functions. Instead, one must use the Modify status manually function.
In Preparings status canceling (recursive) working but have to mark all the tasks manualy and use cancel. Generating status have to be changed manualy. I had few "generating" tasks and use "working for host" on them and then cancel. My problem is how to speed up canceling proces. Is there a way to select every RUN ID at once? The problem is that I don't see main RUN ID that could kill all child tasks.
Ah yes, I may have gotten those to states confused.
If the run ID of the parent workflow is available, you could do something like this:
This SQL query will list the run IDs of all of the tasks in an active workflow.
select--- EH_Name,EJPP_Lnr,EJPP_Object,EJPP_TaskIdnrfrom EH,EJPPwhere EH_AH_Idnr = EJPP.EJPP_AH_Idnrand EH_AH_Idnr = ?and EJPP_OType not in ('<START>','<XTRNL>','<IF>','<FE>','<END>')order by EJPP_Lnr
Replace the bind parameter with the workflow run ID.
I cannot find parent ID. It is a loop on proces that create itself over and over.
Do you mean a FOREACH workflow or something else like a loop in a script? What is the task that is generating these tasks? Can you cancel that task?
I was testing few different tasks with multiple transfers and when copy script from scri to JOBP instead of "set &ret# = activate_uc_object(JOBF.name)" I use set &ret# = activate_uc_object(JOBP.name) and had loop on JOBP itself.
I’d say cancel the task that is running ACTIVATE_UC_OBJECT. This task must have a run ID, no?
If you have many tasks in the Activities table that you want to cancel/deactivate, and if you cannot find a way to do it using AE scripting, and if you do not want to do it manually, then you can always contact CA Automic Support. They can provide an SQL statement that will remove the tasks directly from the relevant tables. You still have to be able to identify the tasks somehow though.
I use old user_interface and can mark 5000 tasks instead of 500 from web interface All hanging tasks killed.
Retrieving data ...