creating a task

[dnfrantum]

Is it possible to create a task in Oracle, e.g. I want to create a query for a report, transform that into a stored procedure, and then run that stored procedure at specific intervals throughout the day.

The stored procedure would be spooling a file to a specific location for pickup by an FTP .bat file.

I seem to remember doing this on ORACLE 8, but I can't remember how.

Thanks in advance,
Donald

 

[lecorr]

You are talking about jobs (DBMS_JOB).

Depending on version, job can (10g>) or cannot (<=9i) execute an external program (to spool in a file).

If you use an stored proc, you will have to use something like utl_file to create and open a file and write in it...

Millions of examples on google...


Hope this helps,

Christian