Hi, I am building a windows service that does the following
1) a System.Timers.Timer elapseed event handler will run code at every
interval, maybe every 2 to 5 minutes or so (i have not decided yet)
2) in the Elapseed event the service will query a table in sql server
and find the 1 oldest row in a table and set the status of that row to
'running'
3) the service will then run a report on the sql server database and
save the results to a excel file. the name of the excel file will come
from that table in sql server. the file is stored on the service's
server's hard drive in c:\folder1
4) the service will then compress the excel file to a zip file of the
same name in c:\folder2. I am using the zipping code from
http://www.icsharpcode.com/OpenSourc.../Download.aspx
5) the excel file in c:\folder1 is deleted
6) the code then uses System.Web.Mail namespace to email the zip file
to the user's email address that was in that table.
7) the code then deletes the zip file.
8) the row in the sql server is then set to 'finished'
9) if there is an error somewhere the row is set to 'failed'
I am just wondering if I have done anything unthreadsafe or file.io
safe. Can you tell me what I can be missing. Do i need to use lock{}
or something?
