Lengkap

automatically email results of sql query periodically

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.

Kemahiran: Pengaturcaraan C#, SQL, Pelayan Microsoft SQL, Kejuruteraan Perisian

Tentang Majikan:
( 20 ulasan ) city, United States

ID Projek: #32762676

Dianugerahkan kepada:

HajiAhmad

As we agreed on the terms please assign me the task so that I can complete it. Thank you Haji Ahmad Khan

$250 USD dalam 7 hari
(21 Ulasan)
5.5

9 pekerja bebas membida secara purata $213 untuk pekerjaan ini

(433 Ulasan)
8.1
(99 Ulasan)
6.7
apgrl123

I CAN COMPLETE YOUR PROJECT EASILY Hello, I am programmer with enough experiences on C#/.NET for 10+ years. C#/.NET is nice programming language and I am majoring on it for long years so I have confident to complete yo Lagi

$200 USD dalam 7 hari
(12 Ulasan)
5.3
mihhailovajulia5

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

$140 USD dalam 7 hari
(5 Ulasan)
4.6
eagleeyesvw

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

$250 USD dalam 15 hari
(61 Ulasan)
4.7
Muhammadsamran

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

$40 USD dalam 7 hari
(13 Ulasan)
4.8
umairkaramat24

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

$250 USD dalam 14 hari
(7 Ulasan)
3.4
tohamelnik

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

$100 USD dalam 3 hari
(0 Ulasan)
0.0