Re: Porting SQL Server job to Oracle

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

Full demo at:
http://www.psoug.org/reference/library.html

Scroll down to DBMS_JOB.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)