Click here to Skip to main content
13,142,065 members (60,122 online)
Rate this:
Please Sign up or sign in to vote.
See more:

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

1 solution

Rate this: bad
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.)

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 |
Web02 | 2.8.170915.1 | Last Updated 26 Dec 2012
Copyright © CodeProject, 1999-2017
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