Saturday, 15 January 2011

sql - How to store Monthly running services in database? -


I am working on a university project in which various reports (annual, monthly, daily). These reports run through the window service. I am thinking of creating a database table.

ID ---- JobName ----- Destination folder ----- Startdate ---- Annual --- Monthly ---- Daily ---- Last cry

I would appreciate that someone can review the design.

In addition, using a Connecting Architecture here is a good idea as the service must run in the background and check the date in the database. If a report has been scheduled to run at that time, then it will run.

You can use a column to tell how it is stored . Then select my when stored_type = 'monthly' .

Or, to make it more relational, create another table where you have stored and used:

  Schedule from SELECT * Type schedule.stored_type_id = type Id WHERE type.id = 1    

No comments:

Post a Comment