By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,867 Members | 1,964 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,867 IT Pros & Developers. It's quick & easy.

Set time to execute the commond

P: 4
In asp page after inserting the records am trying to execute the proceudre below.

I need to set excute time for that procedure to run after specified seconds/minutes once the insert statement executed.

Please help me out, its really very urgent.


Expand|Select|Wrap|Line Numbers
  1. sql_insert = "insert into owf_mgr.request_forms (request_no, request_type, request_date, ustatus, emp_id, user_name,branch,department,job_title,email_id,joining_date,mobile,gender,work_type,manager_email,hardware,email,internet) values ('" & r_new_req_id & "' ,'" & emp_request_type & "',sysdate,'" & _
  2. empstatus & "', '" & empid & "','" & empname & "','" & branch & "','" & divisions & "','" & jobtitle & "','" & emailid & "','" & joiningdate & "','" & mobile & "','" & gender & "','" & worktype & "','" & mgremail & "','" & hardware & "','" & email & "','" & internet & "')"
  3.  
  4. 'response.write sql_insert
  5. 'response.end
  6. 'dim r_new_req_id
  7.  
  8. Set con = Server.CreateObject("ADODB.connection")
  9. con.Open data_source
  10.  
  11. Set Cmd = Server.CreateObject("ADODB.Command")
  12. Set objRs = Server.CreateObject("ADODB.Recordset") 
  13. set Cmd.ActiveConnection = con
  14. Cmd.CommandType = 4
  15. Cmd.CommandText = "MCMSREQ.start_mcms_wf('" & r_new_req_id & "')"
  16. Set objRs = Cmd.Execute
Aug 1 '12 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,370
Please use code tags when posting code.

Just put your program into a loop until said time arrives.
Aug 1 '12 #2

P: 4
Thanks for the response, as am a newbie to asp will be really thankful if you could please show me the sample script.
Aug 1 '12 #3

Rabbit
Expert Mod 10K+
P: 12,370
A loop is a basic concept that all programmers should know. If you don't know how to implement a loop, you should take a class or read a tutorial before tackling a project like this.
Aug 1 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.