Click here to Skip to main content
15,881,757 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
I have a page where users can updae their data. It uses notmal sqlserver update command in asp.net(C#)

Such update commands do the work immediately on click of button.

Now i want to give a liberty to users to select a time at which the data should be updated and not immediately on click of the button.

Can a server keep a note of the time given by users in DateTime format through text box or calender and execute update at that selected time.

Any kind lof help whether code or any tutorial or hint to use the jquery or ajax would be helpful.

Thanks.
Posted
Comments
[no name] 17-Aug-14 18:26pm    
Not sure what "code" you would expect. You need to save the data then create a SQL Agent job, or a scheduled task or a windows service to check the whatever-it-is to perform the action.
Member 10235977 19-Aug-14 12:10pm    
Thanks that now i know that i need to learn Scheduled Task and SqlAgentJob. Kindly suggest some tutorial for that.

1 solution

Yes, Wes is correct. You have to save that somewhere either in file or database. Then you should run a Scheduled Windows App, that would constantly check the stored data and work accordingly.
 
Share this answer
 
Comments
Member 10235977 19-Aug-14 12:11pm    
Thanks that now i know that i need to learn Scheduled Task and SqlAgentJob. I shall be grateful if you could suggest some tutorial on that.
Member 10235977 20-Aug-14 7:17am    
Thanks. it is a good tutorital for beginners like me.
Welcome. Please accept the answer. :)

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