Link to home
Start Free TrialLog in
Avatar of Mike
MikeFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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.
Avatar of Joe Winograd
Joe Winograd
Flag of United States of America image

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
Avatar of Mike

ASKER

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).
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?
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.
Ah, good catch, Qlemo! I missed that.
Avatar of Mike

ASKER

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
Pings? Looks like you are monitoring a lot of different status events and tests ...
ASKER CERTIFIED SOLUTION
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike

ASKER

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