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.
DA Morgan - 31 Mar 2006 17:57 GMT
> Hi,
> I am working on Cognos Decision Stream. I need to run a job stream on a
[quoted text clipped - 7 lines]
>
> TR.
And your Oracle version is?
In 9i or before use the built-in DBMS_JOB package. In 10g use
DBMS_SCHEDULER.

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