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.
Parent topic