Monday, July 31, 2006

how can enable job

when you want to enable job on oracle.


BEGIN
sys.dbms_scheduler.enable( 'JOB_NAME' );
END;

example:

BEGIN
sys.dbms_scheduler.enable( '"MGR"."GET_DATA_FROM_DB1"' );
END;

No comments: