Home » RDBMS Server » Server Administration » Re: how to update a table automatically
Re: how to update a table automatically [message #371589] Fri, 10 November 2000 03:12
John R
Messages: 156
Registered: March 2000
Senior Member
Assuming that your update is done by the procedure pr_update, the following should do it:

DECLARE
l_job binary_integer;
BEGIN
DBMS_JOB.SUBMIT(l_job
,'pr_update'
,sysdate
,'sysdate + (10/(24*60))'
,TRUE)
END;

will fire the job off, starting now and repeating every 10 minutes.

Be sure that the procedure to be run includes a COMMIT.

Hope this helps.

Report message to a moderator

Previous Topic: Dynamic function returning a pl/sql table
Next Topic: Can someone tell me why this update statement is not working....Help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 19:38:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.