Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Blog Directory  >  Software Blogs  >  Programming Blogs  >  HOW TO CREATE AND RUN JOB IN ORACLE programming Blog  > 

How To Create And Run Job In Oracle Blog


techquerypond.wordpress.com
A job object (job) is a collection of metadata that describes a user-defined task that is scheduled to run one or more times. It is a combination of what needs to be executed (the action) and when (the schedule). CREATE OR REPLACE PROCEDURE myproc AS BEGIN INSERT INTO MYTEST(CREATED_ON) VALUES (sysdate); commit; END myproc; / BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => ‘My_job’, job_type => ‘STORED_PROCEDURE’, job_action => ‘MYPROC’, start_date => ’07-AUG-16 07.00.00 PM’, repeat_interval => ‘FREQ=SECONDLY;INTERVAL=5′, end_date => ’20-NOV-18 07.00.00 PM’, auto_drop => FALSE, comments => ‘My new job’); END; / EXEC DBMS_SCHEDULER.ENABLE(‘My_job’);
2016-08-08 15:00
A job object (job) is a collection of metadata that describes a user-defined task that is scheduled to run one or more times. It is a combination of what needs to be executed (the action) an… Read More
2016-03-06 14:32
  “Autonomous Transactions in Oracle” 1)In Oracle session, all of the changes made to data are part of a single transaction. 2)An autonomous transaction is an independent tr… Read More

Share the post

HOW TO CREATE AND RUN JOB IN ORACLE

×

Subscribe to How To Create And Run Job In Oracle

Get updates delivered right to your inbox!

Thank you for your subscription

×