Retrieve all Job Phase failures
An MSP customer, there're a lot of alerts which send out mails whenever any of them detects phase errors, but sometimes the job itself got succeeded, also in this case it's quite difficult to look into the phase errors since the information would be scattered at detailed job results, events, alerts, etc. This query is created by a customer's requiest who want to track job **phase** errors at once, combining many information from various tables including event or error parameters.So some verbose informations there, but you can easily detect when the phase failures happened, like one of MAs is having connection issue and affecting mlutiple jobs. Here's the query, you can run it on CommServ DB, or creating customer reports on your Metrics Reporting could make your life easier.use commservSET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;declare @tmp table ( jobid int ,starttime bi
