Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Chain step - attributes

TatoRoJun 11 2019 — edited Jun 12 2019

Hi there, all.

Oracle manual about Chain in it's part about chain attributes states the list of following attributes:

completed

state

start_date

end_date

error_code

duration

Can someone then explain me what objects of a chain step are assigned in the code herebelow (source of the code):

DBMS_SCHEDULER.ALTER_CHAIN(

        CHAIN_NAME   => 'Rosts_JOB_CHAIN',

        STEP_NAME    => 'Del_from_PVJOURNAL',

        ATTRIBUTE    => 'PAUSE',

        VALUE        => false

    );

In the code I've reviewed I've met following set of such attributes: PAUSE, SKIP, RESTART_ON_FAILURE, RESTART_ON_RECOVERY

What are they if not attributes? Where can I read about their meaning, usage and find a complete list of 'em?

This post has been answered by GregV on Jun 11 2019
Jump to Answer
Comments
Post Details
Added on Jun 11 2019
3 comments
419 views