Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Oracle / Oracle Server / March 2006

Tip: Looking for answers? Try searching our database.

Procedure to run an application everyday.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TR - 31 Mar 2006 17:10 GMT
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)

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.