Home » SQL & PL/SQL » SQL & PL/SQL » How to schedule a job depending on any condition (oracle 10g,windows xp sp3)
How to schedule a job depending on any condition [message #415565] Tue, 28 July 2009 04:34 Go to next message
adusur
Messages: 36
Registered: June 2009
Location: Bhubaneswar
Member
Hi,
I need to schedule a job in such a way that,
The job has to be run automatically after a table is
loaded with the data.

I know scheduling a job to execute at regular intervals.


Please provide a solution as soon as possible.

Thanks in Advance,
Ravi.

[EDITED by LF: specified product and OS after topics have being merged]

[Updated on: Tue, 28 July 2009 04:54] by Moderator

Report message to a moderator

Re: How to schedule a job depending on any condition [message #415566 is a reply to message #415565] Tue, 28 July 2009 04:37 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
That is not really a case for jobs or schedules.

The "Load Table with data" has to be started from somehwere. Just change that to "Load table with data and do the other things"

Re: How to schedule a job depending on any condition [message #415627 is a reply to message #415566] Tue, 28 July 2009 07:58 Go to previous messageGo to next message
adusur
Messages: 36
Registered: June 2009
Location: Bhubaneswar
Member
How can i run the job when data loaded to table?
Re: How to schedule a job depending on any condition [message #415629 is a reply to message #415627] Tue, 28 July 2009 08:00 Go to previous message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
As ThomasG said, just put "in-line" the call to the proc that job is calling in the code that loads data in the table.
Previous Topic: Convert function, problem with fonts
Next Topic: calculate order function (merged for the 5th time!)
Goto Forum:
  


Current Time: Tue Dec 06 00:10:26 CST 2016

Total time taken to generate the page: 0.25965 seconds