We help IT Professionals succeed at work.

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.
Comment
Watch Question

Joe WinogradDeveloper
Fellow 2017
Most Valuable Expert 2018

Commented:
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

Author

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).
Joe WinogradDeveloper
Fellow 2017
Most Valuable Expert 2018

Commented:
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?
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
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.
Joe WinogradDeveloper
Fellow 2017
Most Valuable Expert 2018

Commented:
Ah, good catch, Qlemo! I missed that.

Author

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
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
Pings? Looks like you are monitoring a lot of different status events and tests ...
Distinguished Expert 2019
Commented:
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?

Author

Commented:
Dear David I understand thank you.  I will work through what you suggest.  Does anyone else have any ideas please?  Thanks.  Michael