Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> RE: easy dbms_job.submit question
Andrey,
If you really need to launch script/external commands from DBMS_JOBS, then
you have to go to Oracle 8 and use a
Java stored procedure that can communicate with external programs ... PL/SQL
is unable to do that but through clumsy workarounds like spooling a script
generated from Oracle, using UTL_FILE, then making it executed by the OS
through a cron job (oh yeah, on NT there is an additional tool that does the
same, dunnow the exact name, AT something ...).
Frederic.
-----Original Message-----
From: NetComrade [mailto:andreynspam_at_bookexchange.net]
Sent: 21. januar 2000 20:26
To: comp.databases.oracle.server_at_list.deja.com
Subject: Re: easy dbms_job.submit question
Message from the Deja.com forum:
comp.databases.oracle.server
Your subscription is set to individual email delivery
I think you can only schedule PL/SQL procedures to run thru dbms_job, also you might want to give it specific time, otherwise I would just run the script.
Also if you would like to schedule your script to run at certain
times, I believe NT has an AT command (not sure how to use it), but
the command would look something like:
sqlplus -s user/passworld
@F:\ORANT\BACKUP\LXOF\BACKUPSCRIPT\LXOFBACKUP.SQL
and your script should have 'exit;' as the last line.
As for the newsreader, try free agent at www.forteinc.com
good luck.
On Fri, 21 Jan 2000 18:07:27 GMT, elee3_at_my-deja.com wrote:
>I typed this script in SQL/PLUS, but got INCOMPATIBLE DATA TYPE ERROR
>on the first line. Why?
>
>DECLARE ijob INTEGER;
>BEGIN
>DBMS_JOB.SUBMIT(ijob, 'F:
>\ORANT\BACKUP\LXOF\BACKUPSCRIPT\LXOFBACKUP.SQL', sysdate,1, true);
>END;
>
>When I start a thread on the discusion group, got a reply in my email,
>but I don't know how to find it in deja.com. Am newbie in discussion
>groups. Thanks.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630 AOL: NetComrade ICQ: 11340726 remove NSPAM to email _____________________________________________________________Deja.com: Before you buy.
Sent via Deja.com http://www.deja.com/ Before you buy. Received on Thu Jan 27 2000 - 17:29:25 CST