Set time to execute the commond

[syedraoof]

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.

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,'" & _
empstatus & "', '" & empid & "','" & empname & "','" & branch & "','" & divisions & "','" & jobtitle & "','" & emailid & "','" & joiningdate & "','" & mobile & "','" & gender & "','" & worktype & "','" & mgremail & "','" & hardware & "','" & email & "','" & internet & "')"
 
'response.write sql_insert
'response.end
'dim r_new_req_id
 
Set con = Server.CreateObject("ADODB.connection")
con.Open data_source
 
Set Cmd = Server.CreateObject("ADODB.Command")
Set objRs = Server.CreateObject("ADODB.Recordset") 
set Cmd.ActiveConnection = con
Cmd.CommandType = 4
Cmd.CommandText = "MCMSREQ.start_mcms_wf('" & r_new_req_id & "')"
Set objRs = Cmd.Execute

[Rabbit]

Please use code tags when posting code.

Just put your program into a loop until said time arrives.

[syedraoof]

Thanks for the response, as am a newbie to asp will be really thankful if you could please show me the sample script.

[Rabbit]

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.