I would like to have a simple .net or webapp that I can
Mysql connection information
Log Table Name
Grid with 1 or many "jobs"
+ sign to create new job
if user clicks on new job then a for comes up:
a. Name - Short description
b. Description of Job - multiline fields
b. Frequency - how often it should run
c. mysql query - User(me will put in the exact query I would use in mysql)
d. Email #1
e. Email #2
c. Email #3
Then system will run each query/job at the defined frequencies.
If the query has 0 results then NOTHING HAPPENS
If the query returns any results at all then an email goes to all emails defined for that job.
subject: = "job title"
Body: "Job Description"
Attachment should be a csv. of the mysql results.
Write to log table in db.
Everytime a job runs it should write to the table
ID (auto incrementing)
Date/time it ran
Number of results of query
Emailed - (array of address' it was sent to)
Được trao cho:
11 freelancer đang chào giá trung bình $129 cho công việc này
Greetings, I will use C# net program for your project. I have built Business Account app using C# net a few months ago. So i will give you good result and satisfy. Hire me, I will wait your response. Regards