Accessing data in console application run as scheduled task

Question

Hi, My requirement is to send a mail whenever the status of a set of employees change from 'Active ->Inactive' / 'Inactive->Active' . I have implemented as a console application which is configured in the windows task scheduler to run every 5 mins. This app calls the web service, checks the status and sends mail. But I need the previous execution employee list in order to check if any change in status has occurred or not with the currently retrieved status. I believe static variables won't be of any use as the application is run during each 5 mints. Please advice. Thanks, Divya

Nilesh Shah · Answer

But I need the previous execution employee list in order to check if any change in status has occured or not with the currently retrieved status. I think you are implementing in wrong way, you are here depending on your application to decide if the status is changed or not but in reality it should be dependent on your data - your data should be able to tell you if status has changed or not, in anyway storing status in application in not desirable, if application crashes or machine is restarted then you will status will be lost. is that "web service" written by you or is it third party? if you can create a web service which will give only changed employees then you can achieve it easily. you can track changes in database using triggers.

Accessing data in console application run as scheduled task

Answers (1)