Re: How can I run a procedural in scheduling?

In article <9edlpv$2dkf$1_at_news.itri.org.tw>, Eric <maw_at_tpts5.seed.net.tw> writes:
>Dear All:
> I had a procedural need to run day by day? Had any way to solve it?
>I had find a procedural dbms_aqadm.schedule_propagation. But when I Use
>it,Oracle always had error message "dbms_aqadm.schedule_propagation Not
>Declare!!".
>
>example:
>EXECUTE dbms_aqadm.schedule_propagation( queue_name => 'BOLADM.test');
>
>
>Eric
>
>

The Enterprise edition Advanced Queing option is a store and forward messaging system and I am not sure it is what you want to be using to run a job, which is what your first line said you wanted to do.

Have you looked at the dbms_job package. This package can be used to schedule and execute stored procedures.

• Mark D Powell --
  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net