Jeff Moden (12/17/2014)

---

Brandie Tarvin (12/17/2014)

---

So I have it in my head to design a webpage that my team can pull up at month end and, at a glance, tell what jobs have run, what jobs are running, and what jobs have failed / not run. This wouldn't replace checking our list against the activity monitor, but it would give us a quick heads up on what to check first.

The problem is my Google-Fu does not find the things I think I want to find.

I'm working in Visual Studio 2012. I want VB code that will give me something similiar to the attached picture, but pulling the information from the SQL Server MSDB jobs tables instead of polling file locations to verify the progress of reports (which is what our current Production Monitor process does).

Any hints on what I should be googling or what kind of code I could be pulling to design a page like this?

I built one of those that I receive from each server every morning (I've only got a half dozen that are "production"). It also tells when the next time is that the job will run and the last time the job was modified. It highlights "one time" jobs in Orange and highlights disabled jobs and disabled schedules in Yellow. Of course, any failures or retries are highlighted in Red. I'm considering writing an article on the subject.

But, it's not a web page. It certainly could be because I built it all as HTML from T-SQL but it isn't currently a web page.

Would that do?