dbms_job

[steeve123]

How to run a sql script using the dbms_job package?

[jm]

VARIABLE jno number;

BEGIN
DBMS_JOB.SUBMIT (
:jno,
'my_job;',
SYSDATE ,
sysdate + 1/24'
);
COMMIT;
END;
/

[steeve123]

no, this run a stored procedure in the database

I WANT TO RUN A SCRIPT.

EX:

C:\THIS_IS_MY_SCRIPT.SQL

[jmodic]

You can't unless you call some external or database-stored java function that in turn will run your OS script.

But given it another though, why would you then use DMS_JOB at all? why not simply use OS scheduler (cron, at, ....)? DBMS_JOB is ment to use with stored procedures. OS scheduler is ment to use with OS scripts....

[Edited by jmodic on 05-30-2001 at 05:27 PM]

[steeve123]

i dont want to use **** from nt or unix, i want to use oracle stuff.

[jmodic]

Yeah, well then you'll have to rewrite your SQL*Plus scripts into stored procedures....

[pando]

lol

[hrishy]

Hi

i dont want to use **** from unix or NT ..............i was wunderin waht makes you say so..............always try to make things simple..................dont add complexity unnecssarily..........


regards
hrishy

[steeve123]

ok, then how can i run a script from a procedure?