[ oracle ] how to create a job to run the procedure

รูปภาพ

or using code


DBMS_SCHEDULER.CREATE_JOB(job_name        => v_jobnam,
job_type        => 'PLSQL_BLOCK',
JOB_ACTION      => 'BEGIN DROP_OBJ1(''' || v_objnam
|| ''', ''' || v_objtyp || ''', '''
|| v_schema || ''',' || v_objid
|| '); END;',
start_date      => SYSTIMESTAMP,
repeat_interval => 'freq=secondly; bysecond=0',
end_date        => NULL,
enabled         => TRUE,
comments        => 'Calls PLSQL once');

ref : Vincent Malgrat

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s