RE: easy rdbms_job.submit question

From: Frederic Bidon <fbi_at_mobilix.dk>
Date: Wed, 26 Jan 2000 07:55:43 +0100
Message-ID: <2D3005375CAED31199D00008C784963F020910@ms02.mobilix.dk>

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. Received on Wed Jan 26 2000 - 00:55:43 CST