PL/SQL is there a way to set queries to run automatically?

[comcasttester1]

Hello!

In PL/SQL is there a way to set queries to run automatically? For ex: I have query X that needs to run everyday at 6:00am and be automatically exported to a C drive folder. Is this possible in PL/SQL, or will this

 

[Worker]

I don't think this is possible using only PL/SQL Developer.

Some options I can think of:

• Use Windows' "Scheduled Tasks" in combination with a SQL script run by SQL*Plus or possibly PL/SQL Developer.
• Use "Scheduled Tasks" in combination with a Perl (or Python, or whatever) script that connects, does the query, and writes the result to file.
• Use DBMS_JOB or DBMS_SCHEDULER and create a job in the database that runs the query and then uses UTL_FILE to write the result to a file.

Personally I would use the first option. Also, this may be helpful.

 

[yzsind]

Agree Worker