Re: Porting SQL Server job to Oracle

From: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Fri, 04 Jun 2004 22:21:01 GMT
Message-ID: <hB6wc.28461$OI5.177@edtnps84>

Robert Scheer wrote:

> Hi.
>
> I need to do in Oracle something equivalent to what I do using jobs in
> SQL Server. I have a procedure that needs to insert data from one
> table to another table hourly.
>
> I found that I can use DBMS_JOB to do this, but I could not find
> anything about its syntax. I made a search on the Oracle's site, but
> what I found were sparse articles, none of them explaining exactly how
> to use the utility. Can anyone point me to an article that focuses on
> DBMS_JOB?
>
> Thanks,
> Robert Scheer

asktom.oracle.com

eg.
exec
DBMS_JOB.SUBMIT(:v_jobnum,'your_procedure_here;',TRUNC(sysdate,'HH'),'TRUNC(sysdate,''MI'')+63/24/60'); Received on Fri Jun 04 2004 - 17:21:01 CDT