Wednesday, 2 October 2013

Assign specific Job or Schedule to specific RAC instanace

This is very much effective and simple code for segregating resource to specific RAC instance.

BEGIN
sys.dbms_scheduler.set_attribute( name => 'JOB_NAME', attribute => 'instance_id', value =>1);
END;

BEGIN
sys.dbms_scheduler.set_attribute( name => 'PARSING_NV1GEN1_12', attribute => 'instance_id', value =>1);
END;

No comments:

Post a Comment