Is there a service that will monitor scheduled jobs emails?

I receive loads of emails telling me that scheduled jobs have or have not run properly.  Is there a system that will help me to monitor them and alert me if any do not arrive on schedule or, for instance, listen for specified words like "fail"?  Thanks.
Mike LondonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joe Winograd, Fellow&MVEDeveloperCommented:
Hi Michael,
Can you post a few of the emails? If the "loads of emails" have varying formats, it would be helpful to see what the different formats are. Be sure not to post anything with private/sensitive info in it. Regards, Joe
0
Mike LondonAuthor Commented:
Dear Joe

This is the format of some of the most frequent ones.  Is when a sql backup job has run.  Thanks.

Michael

Processed 10936 pages for database 'live', file 'live_Data' on file 1.
Processed 1 pages for database 'live', file 'live_Log' on file 1.
BACKUP DATABASE successfully processed 10937 pages in 114.182 seconds (0.784 MB/sec).
0
Joe Winograd, Fellow&MVEDeveloperCommented:
How about an email filter/rule that looks for the sender in the From field (which I'm sure is always the same for those notification emails) and fail (or whatever failure indicator string that makes sense) in the Body. I know this is doable in Outlook (Rules) and Thunderbird (Filters) — what email client do you use?
0
ON-DEMAND: 10 Easy Ways to Lose a Password

Learn about the methods that hackers use to lift real, working credentials from even the most security-savvy employees in this on-demand webinar. We cover the importance of multi-factor authentication and how these solutions can better protect your business!

QlemoBatchelor, Developer and EE Topic AdvisorCommented:
This will still not cover "alert me if any do not arrive on schedule", and that part is the hard one. It requires to read out the schedule of tasks or MSSQL Agent jobs, and whether the execution was triggered, and the task / job completed with mail.
0
Joe Winograd, Fellow&MVEDeveloperCommented:
Ah, good catch, Qlemo! I missed that.
0
Mike LondonAuthor Commented:
Thanks for your comments. I came across a system called pushmon but that requires pings to a specified url. Unless I could find some way of getting the emails received to trigger the pings....  Thanks. Michael
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Pings? Looks like you are monitoring a lot of different status events and tests ...
0
David Johnson, CD, MVPOwnerCommented:
what you want needs 2 components
1 being outlook and the second being many task scheduler events
in outlook create a rule which also runs a script (note this will only run if outlook is open).  Each event that you monitor should use a different email from address (just to make things easier on you) also success and failure should use different rules
What the outlook script does is create a 0 byte file that all we need is the date and time and success or failure.. Each monitored event should use either a different base filename or directory and what you will see is the last message received date run by looking at the date/time of the file. you then need a script that will get the latest file and its date time or all of the file date times .. you can then compare the date/time to the current date and if the last report was less than either todays date or todays date/time - x hours create a message box on your screen. Are you getting the gist of what I'm trying to explain?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike LondonAuthor Commented:
Dear David I understand thank you.  I will work through what you suggest.  Does anyone else have any ideas please?  Thanks.  Michael
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Network Management

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.