Dashboard to monitor SQL Job status

Question

HI Guys,

 

I need help on developing a custom solution using ASP.Net. As part of project needs, i want to create a dashboard with the following requirements,

 

Suppose say there are three applications x,y and z . For each application, there are sql jobs scheduled to run on daily/weekly basis. we check the job health status manually. so i am thinking to automate the process by creating a dashboard listing application specific sql job and their health status. also, alert the concern team when the job fails through mailer.

 

if the above said functionality is achieved,then go for generating  graphical reports  of the job status using SSRS reports  so that it will be a easy look on for high level management.

 

Please help me with the basic idea of implementation/genaral architecture of laying down this application. I mean i have queries like how to fetch the job status to the front end.

 

Your help would be greatly appreciated .

 

Regards,

Sivapratap.