Kill Schema Load using CLI

[srini_ch]

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

[dylanwan · Accepted solution]

# ************************************************************************
# Incorta bash api sample force stop schema load job
# ************************************************************************

cur_dir=$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )
incorta_cmd="python $cur_dir/incorta.py"

# login to incorta
# you have to save the session to be used in every other call
session=`$incorta_cmd login <INCORTA_URL> <TENANT_NAME> <SUPER_USER> <SUPER_PASSWORD> <VERIFY_CERTIFICATE>`
# e.g. session=`$incorta_cmd login http://localhost:8080/incorta demo super super`

# Stop if login failed
if [ -z "$session" ]; then
    exit 1
fi

#force stop loading job for specified schema
$incorta_cmd force_stop_schema_load $session schema_name
# e.g. $incorta_cmd force_stop_schema_load $session 'SALES'

# log out from the server
$incorta_cmd logout $session