Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: easy rdbms_job.submit question
CRON for unix
AT fot NT
On Wed, 2 Feb 2000 14:50:38 +0100, Frederic Bidon <fbi_at_mobilix.dk> wrote:
>You are definitely right. I focused so much on the wrong syntax Elizabeth
>gave us that I didn't even notice that it was a file in the argument ! Of
>course it is not possible, no question about that.
>Since, executing an external procedure is an interesting issue, and it can
>be done through a java call I think (8i).
>
>Frederic.
>
>-----Original Message-----
>From: Martin Haltmayer [mailto:martin.haltmayer_at_0800-einwahl.de]
>Sent: 26. januar 2000 12:58
>To: comp.databases.oracle.server_at_list.deja.com
>Subject: Re: easy rdbms_job.submit question
>
>
> Message from the Deja.com forum:
> comp.databases.oracle.server
> Your subscription is set to individual email delivery
>
>I guess that this will not work. The "what" parameter (#2) must be the
>name of a PL/SQL procedure, not the name of a script file! Maybe you can
>run your script with Intelligent Agent but definitely not by
>DBMS_JOB.SUBMIT!
>
>Martin
>
>
>
>Frederic Bidon wrote:
>>
>> Hi Zbeth,
>> It seems that they're some missing parts in your understanding of PL/SQL.
>> But the best way to learn is to try, and try again.
>> Try this, I always do it like that (in an anonymous PL/SQL block) :
>>
>> DECLARE
>> job INTEGER;
>> no_parse BOOLEAN:=TRUE;
>> BEGIN
>> DBMS_JOB.SUBMIT
>> (job,
>> 'E:\ORANT\RDBMS\BACKUP\LXODBACKUP.SQL',
>> sysdate,
>> 'SYSDATE+1',
>> no_parse)
>> END;
>> / (/ in SQL*PLus of course)
>>
>> For other PL/SQL questions, purchase the excellent Oracle PL/SQL
>> programming from Oracle Press by Scott Urman, and visit www.revealnet.com
>> where there is a PL/SQL pileline chat and some other good advices from
>Steve
>> Feuerstein, a PL/SQL guru.
>>
>> Frederic.
>>
>> -----Original Message-----
>> From: elee3_at_hotmail.com [mailto:elee3_at_hotmail.com]
>> Sent: 20. januar 2000 22:51
>> To: comp.databases.oracle.server_at_list.deja.com
>> Subject: easy rdbms_job.submit question
>>
>> Message from the Deja.com forum:
>> comp.databases.oracle.server
>> Your subscription is set to individual email delivery
>>
>> This is a backup script job. What is wrong with this syntax?
>>
>> PROCEDURE DBMS_JOB.SUBMIT
>> (job OUT BINARY_INTEGER,
>> 'E:\ORANT\RDBMS\BACKUP\LXODBACKUP.SQL' IN VARCHAR2,
>> sysdate,
>> 1,
>> no_parse)
>>
>> Thanks,
>> Elizabeth
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>>
>> _____________________________________________________________
>> Deja.com: Before you buy.
>> http://www.deja.com/
>> * To modify or remove your subscription, go to
>> http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.server
>> * Read this thread at
>> http://www.deja.com/thread/%3C867vv3%24or9%241%40nnrp1.deja.com%3E
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
>
>
>
> _____________________________________________________________
> Deja.com: Before you buy.
> http://www.deja.com/
> * To modify or remove your subscription, go to
> http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.server
> * Read this thread at
> http://www.deja.com/thread/%3C388EE158.3CF6E1C4%400800-einwahl.de%3E
>
>
> 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 emailReceived on Wed Feb 02 2000 - 14:00:43 CST