The command “job status” provides the listing of all the jobs run in the past which are retained in the history as determined by the setting of the parameter SP_SYS_JOB_HISTORY_RETENTION. For reasons, like having too many such jobs residing in history, one may want to exclude some of the jobs. This solution delves on achieving this objective.
Too many entries in the "job status" output.
By issuing the command “copy status” or “show compare” from source sp_ctrl, the PID of the respective compare or copy jobs can be obtained. Based on that information, you can issue the command “clear history <id>” from the source sp_ctrl to permanently remove that job from history. From this time on, if the command "job status" is issued, that job will not show up in the output.
Another indirect way to reduce the size of the history retention is to set the parameter SP_SYS_JOB_HISTORY_RETENTION lower from its default value of 90 days. For example, if you want to see the jobs from the past 30 days only, instead of the default 90 days, set the parameter as below:
sp_ctrl>set param SP_SYS_JOB_HISTORY_RETENTION 30
Then shutdown Shareplex and restart it for the parameter to take effect.
