Click here to Skip to main content
12,510,594 members (49,238 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: Oracle
Hi,

i got one requirement like i have to schedule one procedure which is running in other than peak hours.

can any body help me how to automate the job in Oracle10g.
actually i studied about dbms_scheduler but it is not understood by me.

assume i have the table like

crate table t1(id number,name varchar2(10))

insert into t1 values(101,'testjob')

now give me one example like every day 12AM i have to run my insert script i.e how can i automate it.
Posted 11-Dec-12 2:41am
Updated 11-Dec-12 19:05pm
v2

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

You need to create a JOB, this will execute whatever you want.

here is a few links:
Docs Oracle (with example)[^]

Another step-by-step[^]

and the last, but better:
Creating Jobs in Oracle Enterprise Manager Grid Control 10g Release 2 (With Screens of EM.)
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160929.1 | Last Updated 26 Dec 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100