If I have authored and enabled a bunch of Automation Rules, I'd like to programmatically know when the entire set has finished running. As you probably know, they run in random order, so it's not like I can simply add some sort of event notification to the last one and wait to receive that event.
What do you recommend?
I see from the SPAdmin/Automation/Monitoring module that the administrator can monitor when these Automation Rules run, and eventually finish. Is this information also available via SPS SDK? (or, perhaps certain table(s) within the SPS db ?)
Code: Select all
SELECT TOP (1000) O.Number as 'File Number' ,AI.ExecutionCorrelation as 'Automation Instance' ,AI.QueuedOn as 'Automation Queued On' , AI.LastRunOn as 'Automation Last Run On' , AI.Reason as 'Auotmation Message' ,[Level] ,[User] ,[Message] FROM [SelectDb].[pf].[OrderLog] as OL Left Join pf.[Order] as O on OL.RootID = O.RootID Left Join [SelectDb].core.AutomationInstance as AI on O.Guid = AI.ExecutionCorrelation Where OL.RootID = '-2147483639'