Post reply

How to implement a 'timer' or 'scheduling' feature using .NET and SQL Server

  • June 2, 2008 at 3:23 pm

    #122512

    Has anyone implemented a ‘timer’ or ‘scheduling’ feature in .NET 2.0 with SQL Server 2005 as the back-end? I will need to implement this feature where additions or updates made on the .NET application will be scheduled to post at a future date and time as specified in the application. These changes will update the database and become live and viewable by the user only when the date and time is reached. For example, the user should be able to add a record and specify a date and time when the record will post to the database.

    Any advise is appreciated!

  • June 2, 2008 at 3:25 pm

    #823332

    Service Broker might help here. I suppose you could delay messages until some time.

    The other thing is perhaps insert the data into a Q table of some sort with a future date. read the table every minute or so and apply the updates that make sense.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply