How to kill a job in SharePlex session (4243236)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How to kill a job in SharePlex session
Description

Have a compare job running that needs to be stopped
Cause

need to stop a compare / repair job
Resolution

The command to stop a compare is
sp_ctrl> cancel job_id
sp_ctrl (avrstones:8606)> compare using chainer_local.conf
comparing 1 of 1 objects
compare started; job id 5
sp_ctrl (avrstones:8606)> show compare
The syntax to get status for the compare command has changed
Instead of 'show compare' use the 'compare status' or 'repair status' command
Job ID : 5
PID : 6226
Host : avrstones
Started : 13-MAR-15 05:18:43
Job Type : Compare
Status : Processing - 0 objects completed
ID Tablename Status Time Total Rows %Comp Total Time
------ ------------------------------------ ---------- ---------- ---------- ----- ----------
1 "KDILLON"."CHAINER" Fetching.. 0:03 0 0:10
sp_ctrl (avrstones:8606)> cancel 5
Canceled job 5
sp_ctrl (avrstones:8606)>
Additional Information

Sometimes the compare process still exists at OS level ands it can be killed using kill command at OS side, The corresponding process on target will also get cleared on its own. If, for any reason the target process does not go away on its own, one may want to issue "kill" on it as well. you can find process pid in compare status command output.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title