Hello,

I want to run a .sql file(not a pl/sql block) in the DBMS_JOB periodically which implicitly generates and executes another sql (using spool command), consiting of some ten commands.

I used the following commands:

SQL>variable x number;
SQL>exec dbms_job.submit(:x,'xyz;',sysdate,'sysdate+1',null)

But here what I understand is xyz must be a procedure.

1. Is there a method to use an sql block in a dbms_job?

or

2. Is there a method to use an sql script in a procedure?

If so, please let me know.

Any help is appreciated.

Thanks..
Shailender