Build a script runner

I would like to have a simple .net or webapp that I can

1. Config

Smtp information

Mysql connection information

Log Table Name

2. UI/GUI

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.

Email:

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

Columns:

ID (auto incrementing)

Job title

Date/time it ran

Number of results of query

Emailed - (array of address' it was sent to)

.NET Programování v C C# Programování MySQL Softwarová architektura

Identifikační číslo projektu: #18894596

O projektu