
Kill Schema Load using CLI
Hello Community!!
Can you please provide any info on how to kill any particular running schema load jobs using CLI? Our ultimate goal is for automating to kill any loading jobs for particular schema if it exceeds the threshold time while extraction or enriching states without having any manual intervention.
Thanks,
Srinivas Chava
-
Dylan,
We are using 4.8.1 version. I don't find this script under IncortaNode/bin directory. Can you please share this script?
Srinivas,
We have built custom scripts by retrieving details from Incorta metadb (oracle) table -> LDR_JOB_DETAILS to find active schema load jobs. Our requirement is to alert the support team rather than killing the active job. This approach is very effective and we are able to get the duration of the active schema job and act accordingly.