By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,504 Members | 1,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,504 IT Pros & Developers. It's quick & easy.

scheduling a PL/SQL proc / function

P: n/a
Hi NG

is it possible to schedule a PL/SQL proc / function "inside" ORACLE ?

Thanks
Peter

Jul 19 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
lookup DBMS_JOBS

is this a project or are you studying for a test?
"Peter Jenny" <Pe*********@cedes.com> wrote in message news:c0**********@rex.ip-plus.net...
Hi NG

is it possible to schedule a PL/SQL proc / function "inside" ORACLE ?

Thanks
Peter
Jul 19 '05 #2

P: n/a
"Peter Jenny" <Pe*********@cedes.com> wrote in message news:<c0**********@rex.ip-plus.net>...
Hi NG

is it possible to schedule a PL/SQL proc / function "inside" ORACLE ?

Thanks
Peter

--


yes.
Please refer to the documentation on the dbms_job package

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #3

P: n/a
"Peter Jenny" <Pe*********@cedes.com> wrote in message news:<c0**********@rex.ip-plus.net>...
Hi NG

is it possible to schedule a PL/SQL proc / function "inside" ORACLE ?

Thanks
Peter

--


See the Oracle Supplied PL/SQL Packages manual for DBMS_JOB. This is
an internal job scheduler package.

Also when a newsgroup has sub-groups you should generally post in the
appropriate sub-group and not the group.

HTH -- Mark D Powell --
Jul 19 '05 #4

P: n/a
"Peter Jenny" <Pe*********@cedes.com> wrote in message news:<c0**********@rex.ip-plus.net>...
Hi NG

is it possible to schedule a PL/SQL proc / function "inside" ORACLE ?

Thanks
Peter

--

Look into the dbms_job package
Jul 19 '05 #5

P: n/a
> Peter Jenny wrote:

Hi NG

is it possible to schedule a PL/SQL proc / function "inside" ORACLE ?

Thanks
Peter


Oracle provides a LOT of related capabilities. As others have
mentioned, you want to start with DBMS_JOB. For more advanced
capabilities, you want to wander around their Advanced Queueing,
Workflow and Business events.

<rant>
This is ALL documented in the online documentation about included
packages. Go to http://docs.oracle.com, dig into the docs for your
version, use the 'list all books' capability and just spend 3-5 minutes
looking at the titles. It's well worth you time (and ours) to get
familiar with what's available.
<\rant>
/Hans
Jul 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.