Databases
StackOverflow2013
Postsdbo
POHow can I do Time based / scheduled events in .NET?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow can I do Time based / scheduled events in .NET?
    primarykey
    data
    text
    <p>I need to offer scheduling of actions/events, in our web site. A crap analogy could be a calendar system, where a person adds a calendar item and when the date/time has been 'hit', then some logic (eg calculate a report) is fired.</p> <p>I could be having hundreds and even thousands of scheduled events that are entered by my clients. When a client enters something to get scheduled, I will save that info to the database. Then i'm guessing i'll added an event/job somewhere, which will contain the database table primary key. when the event is to be fired, i'll grab that info from the db, then do the logic. done.</p> <p>What are some common solutions to handle this?</p> <p>I'm using .NET 3.5 SP1. DB is Sql Server 2008. UI will be webbased though.</p> <p>I wasn't sure if people use MSMQ? Or something built into Sql Server? Or some open source library (eg. <a href="http://quartznet.sourceforge.net/index.html" rel="nofollow noreferrer">Quartz.NET</a>) with an NT Service. Server will be windows 2008 standard edition.</p> <p>Also - please not suggestions to use a cron job equivalent or any command line scripts, etc.</p> <p>Finally, and this is a secondary objective .. i'd love to throw this up onto azure for shiz and giggles ... so is the also possible? it's only a wish list idea. I would prefer to do it on a dedicated box if the solution is easier, than using Azure.</p> <p>cheers :)</p> <p>edit: Logic to process when an event is required to be fired, are background jobs. No UI required.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USQuintin Par
    1. USPure.Krome
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow can I do Time based / scheduled events in .NET?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow can I do Time based / scheduled events in .NET?
      1. USbashmohandes
      1. VTFavorite
    3. VO
      singulars
      1. POHow can I do Time based / scheduled events in .NET?
      1. USAhmad Mageed
      1. VTFavorite
    1. CO@Pure: Related http://stackoverflow.com/questions/542804/asp-netbest-way-to-run-scheduled-tasks
      singulars
      1. POHow can I do Time based / scheduled events in .NET?
      1. USSam Saffron
    2. COAt what time granularity can they schedule events (second, minute, 15 minutes, 30 minutes, on the hour, etc.)? How many users are we talking about here?
      singulars
      1. POHow can I do Time based / scheduled events in .NET?
      1. USJP Alioto
    3. COTime granularity is: year / month / day / hour / minute.
      singulars
      1. POHow can I do Time based / scheduled events in .NET?
      1. USPure.Krome
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload