Home » SQL & PL/SQL » SQL & PL/SQL » JOB scheduler. (How to make update thru JOB scheduler?)
icon6.gif  JOB scheduler. [message #274543] Tue, 16 October 2007 06:34 Go to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Hi,

I want to update a table - date field by every 1 hour.
How to schedule it using dbms_job?

PLease help me.

Ex: create table temp( now timestamp);

How to schedule it for updating time?

-thiyagu
Re: JOB scheduler. [message #274548 is a reply to message #274543] Tue, 16 October 2007 06:54 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you understand in the dbms_job documentation?

Regards
Michel
Previous Topic: problem with my delete procedure
Next Topic: I am creating one file using utl_file package
Goto Forum:
  


Current Time: Thu Dec 08 16:39:40 CST 2016

Total time taken to generate the page: 0.08367 seconds