Bricklen wrote:
> 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');
>
Don't forget to commit after you enter your job (and declare your
variable beforehand, like so: var v_jobnum number <Enter> ....)
Received on Fri Jun 04 2004 - 17:22:56 CDT