Automic Workload Automation

Hello.

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.

Hi Szymon,

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.

Thank you,

Lucy

Hello.

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?

Szymon

Hi Simpleuser,

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.  

Hello.

Thanks

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.

Hi Michael.

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:

1. Write an SQLI VARA that lists all of the run IDs of the child tasks of a workflow with a specified run ID.
2. Write a script that parses this VARA using PREP_PROCESS_VAR, and for each run ID in the data sequence, cancels the task using CANCEL_UC_OBJECT.

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_TaskIdnr
from EH,EJPP
where EH_AH_Idnr = EJPP.EJPP_AH_Idnr
and 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.