2020-06-13 11:02
Autotrace In The Oracle Database =============== TECH QUERY POND ============== ===== Autotrace In The Oracle Database ==== Available options 1.SET AUTOTRACE OFF : its by default opti… Read More
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
Tags:
col columnname
transaction
set autotrace
mongodb
main transaction
acircacirc returns
exists
oracle dba
oracle
col columnname format
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’);
2020-06-12 09:12
JSON_QUERY In Oracle 12c Database =============== TECH QUERY POND ============== ===== JSON_QUERY FUNCTION IN ORACLE DATABASE 1) ‘$’ : returns the specified string… Read More
2020-05-26 14:16
======== TECH QUERY POND =========== ==== INDEX IN MONGODB…. 1.MongoDB Index 2.Create index : db.employee.createIndex({department: 1}) 3.Finding the indexes : db.employee.getIndexes()… Read More
2020-05-25 05:46
======== TECH QUERY POND =========== ==== SQL PLUS FORMATTING OPTIONS…. SET LINESIZE col COLUMN_NAME format a15 col COLUMN_NAME format $999,99,999.99 Read More
2020-05-20 15:09
====== TECH QUERY POND ======= Exists Clause in Oracle. ======================== 1.The Exists keyword evaluates true or false, but the IN keyword will compare all values in the corresponding… Read More
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-04-11 03:43
Oracle DBA How to create procedure Using Sqlplus Oracle DBA How to create procedure Using Sqlplus TO Connect Database 1) Open command Prompt. 2) SET ORACLE_SID=DATABASE NAME 3) SQLPLU… 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
Subscribe to How To Create And Run Job In Oracle
Get updates delivered right to your inbox!