Renew Publish a Batch Job Stream Definition
Sometimes a batch job stream run can be stuck “Running” in DBMS
scheduler and there is no way to get out of this stuck/stranded situation.
Interrupting a stream run also may not work. In this situation, Renew
Publish option can be used. This option re-publishes the stream in
DBMS scheduler with a different name(same name suffixed with version
number and incremented for every renew click) so further scheduling
can continue. For example, if the stream name is HOURLY, clicking
on renew publish would re-publish stream as HOURLY2 in DBMS scheduler.
Note: “Renew Publish” option should only be used when a stream is stuck/stranded
in “Running” state. Additionally, this option should be used only
after using the Interrupt option and it does not work and job stream
continues to be stuck in “Running” state.
A job stream that is re-published via Renew Publish option has it’s name suffixed with incremental numbers in DBMS Scheduler. For example, if the stream name is HOURLY, clicking on renew publish would re-publish stream as HOURLY2 in DBMS scheduler. It is important to take note of this to make sure there is no other stream in the system with stream name suffixed with numbers such as HOURLY2 in given example as then the “Renew Publish” option would fail.