Create one window service to update sql data in the form of json based on the DateTime column
$10-30 USD
I përfunduar
Postuar over 3 years ago
$10-30 USD
Paguhet në dorëzim
Action items:
1) Create one window service to update sql data which in the form of json based on the End Date Time column.
Example:
-There are 2 main column in the table; Column A (Status) Column B (End Date Time)
-Column A will be filled with the current task status such as 'Draft', 'In progress', etc..Column B will be filled with the plan end date time of the task; input by user.
-Required scenario; if the end date time > current time, automatically the status change to 'Expired', thus the services is required to check and compare the end date time each 1 hour, and insert the 'Expired' status in the column B if end date time > current time.
-User also able to change the frequency of service checking from 1 hour interval to any other interval (in hour) via config file
Hello,
As an expert in SQL, i am very much interested to do this project. If you want, i can create a C# based windows service program for this, i guess this task could also be done by sql job. I need a bit clarification, let's discuss more in detail.
Thanks
$30 USD në 1 ditë
5,0 (209 përshtypje)
7,5
7,5
5 profesionistët e pavarur ofrojnë mesatarisht $48 USD oferta për këtë punë
Hi there!
i wanna do this job for you, I have 5.0 rating and in top 8% freelancers on face of this planet, I can do this for your company sir, lets have a chat :)
Best:
Ali Mumtaz Noor
Hi Client.
I have experience working with C# code and SQL server. I can help you in creating the windows service. Please reach out on chat to discuss further. Thanks.
Regards,
Vinod
i can create a windows service that will run every 1 hour( configurable) and check database column to see if end time has reached from current time. then update status of column to expired.
i have developed windows services