Click here to Skip to main content
14,924,336 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
I want to implement automatic query execution in several intervals.According to the time limit given by the user i need to execute the query automatically...plz help me to do it.
Posted

You can configure your query into the database itself. You configure your query as the job in database which will run in particular time interval as per the user requirement.
The jobs are available in both oracle and MSSQL server database
   
Comments
Member 9492907 13-Oct-12 7:28am
   
Is it work on SQL 2008.....if yes what i want to do to make it happen. plz gve me a clear picture..
Think On 18-Oct-12 9:08am
   
Please Refer the link for your understanding
http://www.codeproject.com/Articles/376731/A-scheduler-GUI-for-SQL-Server-Agent

http://www.dailycoding.com/Posts/step_by_step_guide_to_add_a_sql_job_in_sql_server_2005.aspx
Use Timer Control to execute query in several intervals.
Set interval of Timer as par requirement of users.
Insert your code into Tick Event of Timer.
   
Comments
Member 9492907 13-Oct-12 8:11am
   
I had tried the timer...I used the script manager and use a update panel ..inside the panel i put the timer..but i got an unknown error msg...do u know how it will work properly..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900