Re: easy rdbms_job.submit question

On Thu, 20 Jan 2000 21:50:34 GMT, elee3_at_hotmail.com wrote:

>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.

Everything...
declare
ijob integer;
begin
dbms_job.submit(ijob, 'E:\ORANT\RDBMS\BACKUP\LXODBACKUP.SQL', sysdate, 1, true);
end;

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Jan 20 2000 - 16:26:52 CST