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.

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@x.washington.edu
(replace x with u to respond)