Report Scheduler c# GUI and SQL schema help
-
Hi there we have an in-house reporting system that I have been tasked to create a report scheduler for, I am thinking of mimicking the interface used in Windows for Scheduled Tasks so will build a GUI in c# where you choose from radio buttons Daily Weekly Monthly One time only then configure the options depending on which first option you chose, configure your report parameters and save. This info will all be saved in the Database in my own schema (yet to define) and will be run via a scheduled sql job that processes all the data and emails out the reports. The report scheduler GUI will be a client side process users will do in our organisation and the sending of reports server side. I already have all the code for creating the reports with the defined params and emailing out reports via a sql job. My question is what schema to use for saving the schedule/period data? I have made a start but can be quite complicated and I'm sure someone has done this before or knows how Windows Scheduled Tasks does it. Also is there a code project example of the GUI for this already somewhere? I couldn't find anything. Something that looks kind of like http://www.recrystallize.com/merchant/crystaldesk/reportscheduler.htm Thanks, m.