Mike
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.
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).
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dear David I understand thank you. I will work through what you suggest. Does anyone else have any ideas please? Thanks. 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