Home » SQL & PL/SQL » SQL & PL/SQL » submit a process without waiting
submit a process without waiting [message #262109] Fri, 24 August 2007 09:38 Go to next message
subusona
Messages: 70
Registered: March 2005
Location: delhi
Member
User would like submit a job/process from web application but he should not wait for the process to complete.
he can carry out his other work in application.e.g say user wnat to know the defaulters who have not paid their tax.
A submit button at application will call a procedure say show_defaulters which will actually insert the defaulters records into a ne table.
Lets suppose this process takes 5 minutes. Then the user have to wait for 5 minutes for the process to complete. Requirement is
that he will just submit and will continue to carry out other activities.
Let me know how this can be solved.
Re: submit a process without waiting [message #262111 is a reply to message #262109] Fri, 24 August 2007 10:01 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
DBMS_JOB / DBMS_SCHEDULER
Re: submit a process without waiting [message #262116 is a reply to message #262109] Fri, 24 August 2007 10:10 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>DBMS_JOB / DBMS_SCHEDULER
Yes, but client will never see any results from the processing.
Re: submit a process without waiting [message #262322 is a reply to message #262116] Sun, 26 August 2007 02:56 Go to previous messageGo to next message
cmerry
Messages: 109
Registered: November 2005
Location: Idaho
Senior Member
True, the client does not inherently receive feedback; however, it can query the data dictionary (USER_JOBS, USER_SCHEDULER_JOBS, and/or USER_SCHEDULER_JOB_RUN_DETAILS). The ability to create chains in DBMS_SCHEDULER also provide many options here as well.
Re: submit a process without waiting [message #262351 is a reply to message #262116] Sun, 26 August 2007 07:32 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
anacedent wrote on Fri, 24 August 2007 17:10
>DBMS_JOB / DBMS_SCHEDULER
Yes, but client will never see any results from the processing.

That is the logical result of not wanting to wait for completion. You cannot have both.
Previous Topic: What could be wrong with DBMS_STATS
Next Topic: plsql pb
Goto Forum:
  


Current Time: Sun Dec 04 02:47:10 CST 2016

Total time taken to generate the page: 0.09700 seconds