471,092 Members | 1,539 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

scheduling a PL/SQL proc / function

Hi NG

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

Thanks
Peter

Jul 19 '05 #1
5 5282
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
"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
"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
"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
> 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.

Similar topics

6 posts views Thread by Tony Proctor | last post: by
4 posts views Thread by Nyul | last post: by
3 posts views Thread by Alphonse Giambrone | last post: by
4 posts views Thread by Dinsdale | last post: by
Ritchie
2 posts views Thread by Ritchie | last post: by
5 posts views Thread by Peter Jenny | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.