Re: Procedure to run an application everyday.

TR wrote:
> Hi,
> I am working on Cognos Decision Stream. I need to run a job stream on a
> daily basis which contains fact builds. I do not have much knowledge
> of pl/sql. In decision stream I have a sysdate function. I want to run
> this job stream every day whenever the sys date changes.
> Can any one please guide me how to do this? I would really appreciate
> your help.
>
> Thank you.
>
> TR.

And your Oracle version is?

In 9i or before use the built-in DBMS_JOB package. In 10g use DBMS_SCHEDULER.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)