dbms_scheduler.set_attribute sets/modifies the attribute of a scheduler object.
dbms_scheduler.set_attribute is overloaded so that the value of the attribute can be set with different data types:
dbms_scheduler.set_attribute (
NAME => '…',
ATTRIBUTE => '…',
VALUE => '…' -- Boolean, date, timestamp, timestamp with time zone, timestamp with local time zone or interval day to second.
);
Some attributes can be set to two (varchar2) values:
dbms_scheduler.set_attribute (
name => '…',
attribute => '…',
value => '…',
value2 => '…'
);
In order to set an attribute to null, dbms_scheduler.set_attribute_null must be used:
dbms_scheduler.set_attribute_null(
name => '…'
attribute => '…'
);