Oracle Job Scheduler example

Recently I helped somebody setup a Job to update some tables from a remote database.
So I thought I would give some example here on how to create and track jobs using the Oracle Job Scheduler

begin
drop table test2;
create table test2 (f1 varchar2(10));
dbms_scheduler.drop_job('JJ');
dbms_scheduler.create_job(
job_name => 'JJ'
,job_type => 'PLSQL_BLOCK'
,job_action => 'begin insert into test2 values(''abc''); end; '
--,job_action => 'null;'
,start_date => systimestamp
,repeat_interval => 'FREQ=MINUTELY; INTERVAL=1'
,enabled => TRUE ,comments => 'Job.');
dbms_scheduler.set_attribute('JJ', 'logging_level', dbms_scheduler.logging_full);
dbms_scheduler.set_attribute('JJ', 'job_priority', 1);
end;

-- Run Job nowbegin dbms_scheduler.run_job('JJ'); end;
select * from user_scheduler_job_log where job_name = 'JJ';
-- Job History
select * from user_scheduler_job_run_details where job_name = 'JJ';
select * from user_scheduler_jobs where job_name = 'JJ'';
-- Jobs that are running now
select * from user_scheduler_running_jobs where job_name = 'JJ';

Troubleshooting Job Scheduler Problems

Comments

Post a Comment

Popular posts from this blog

Spring Framework

Spring is a J2EE framework and aims to simplify J2EE development Lightweight – A non invasive container that can assemble set of loosely coupled POJOs. This allows software components to be tested in isolation Abstract Transaction Manager – Allows for pluggable transaction managers, not tied to J2EE environments JDBC abstratcion layer – meaningfull exception hierarchy (no need to extract vendor codes from SQLException) simplified error handling. Integrartes with Toplink, Hibernate, JDO and iBATIS SQL maps AOP functionality – can AOP any object and add aspects such as declarative transaction management. Transaction management can be done without EJB or JTA A flexible MVC architecture – Can work with Struts, WebWork or Tapestry and accomodates multiple view techonlogies like JSP, Velocity, Tiles, iText and POI Spring uses a setter based dependancy injection pattern (Inversion of Control) See my Spring AOP Sample Book Reference: Pro Spring by Rob Harrop Jan Machacek
Read more

Never use a String

http://stephan.reposita.org/archives/2008/05/02/never-never-never-use-string-in-java-or-at-least-less-often/ An excellent post on why you should minimize using String, int and other Primitive Data Types.One advantage I personally see is in the Code Completion feature of Oracle JDeveloper where it will show me the data type for the methods but not the variable name. One should be careful of not overdoing this approach as it can make your code a lot more verbose.
Read more

JSON Web Token

JWT or JSON Web Tokens can be used for securely transferring data between two apps. You can use this to build a lightweight Single Signon functionality within your webapps. An Introduction to JSON Web Tokens in Plain English
Read more