Dynamics Crm 2013 Sql System Jobs Monitoring

less than 1 minute read

Last one for today.. Another instance of me using SSRS to send me emails every day, just so I can keep track of system wide errors. Nice for workflows and custom code we use internally which fails. Obviously half of them I have to source to our developers.. But, information is useful.

SELECT CreatedOn, Name, FriendlyMessage, Message, RegardingObjectIdName, OwningExtensionIdName   FROM [INV_MSCRM].[dbo].[AsyncOperationBase]   WHERE FriendlyMessage is not null and CreatedOn >= getDate() - 1
   order by createdon desc`