automatically email results of sql query periodically
Bajet $30-250 USD
I need a small app that can be installed and connect to a sql express db.
The app will run a predefined query and email the results as an embedded table in an email to a user.
The query needs to accept several variables.
The app should have its down db to store:
a) recurring reports table: queries to be run, variables to run the queries, email address of recipients and frequency to email.
b) settings table: email server sign in info and data needed to connect to sqlserver db for related query data
c) log of reports sent
An example use case:
Each of our users receives survey ratings throughout the day. In the report table, we would provide the query text (it would likely include some sort of placeholder variables), the userID#, user email address, daily frequency, getdate() and user email. The query would be run filtering for items received for that user ID and the getdate() data. Those results would be emailed to the user email address as a table embedded in the email. In terms of scale, i would expect the data being emailed is between 0-20 rows per user per day. There are approx 10 users which will be setup to receive reports.
Deliverables will include all code in visual studio which can be reviewed and compiled. We will also need an installer. This should run as a system service in windows server.
50% milestone on proof of concept (remote session showing it working on your machine or sending of code to be compiled) and 50% upon successful testing of application.
Dianugerahkan kepada:
As we agreed on the terms please assign me the task so that I can complete it. Thank you Haji Ahmad Khan
9 pekerja bebas membida secara purata $213 untuk pekerjaan ini
Hello. I have read your description very carefully and I can complete it perfectly in short time. I am confident in my skills and always value for client's trust. So I have rich experience in these fields. I can use th Lagi
Hi, Based on your requirements, i will fulfill all the tasks required by you. I am a c# .net expert with many projects in my profile. professional expertise in sql server database. Please discuss on chat you can c Lagi
Hello Sir/ Ma’am A skilled full stack developer, I have rich experience in JAVA,C, C++, C#, Python, .NET , MYSQL, SQL, IONIC , MATLAB,PHP and ARDUINO. I am very confident with my skills and I'd like to help your bu Lagi
Hello sir how are you doing? I have read the project detail and really interested in your project, I am full stack developer with multiple frameworks, I have great experience doing similar jobs regarding to these skill Lagi
Dear client! At first, I wish you the best of luck in everything. I am honored to be contacted with you. I've just read your project description carefully and got interested this project because it fits on my skills. I Lagi
