manually trigger sql assessments
Would be great to be able to trigger a refresh of the SQL assessment and email the results instead of waiting for the normal refresh cycle for the SQL assessments.
Stopping and starting the agent, in the absence of a ‘synctime’ (see thread here https://social.msdn.microsoft.com/Forums/azure/en-US/a0b938c9-ed0f-4649-9f43-7aa14cd42ec4/controllingscheduling-advisor-runtime?forum=opinsights ) will force it to re-run. But we prevent it from running more frequently than 4 hours to minimize performance issues.
Are you in SCOM or Direct agent?
For SCOM we might be able to whip up a ‘task’ to click in console… otherwise there is no other infrastructure at the moment that allows ‘pushing’/triggering tasks from the cloud onto agents – the solution packs only contain a bunch of MPs that get downloaded every few minutes and contain RULEs that run on a schedule… ; probably future enhancements / deeper integration with the Automation engine might make this possible.
Will pass along to the team, thanks for the feedback.
For the way we think about ‘emails’ – it’s more as in alerts notifications at this stage – see this other item http://feedback.azure.com/forums/267889-azure-operational-insights/suggestions/6519198-long-running-saved-searches-or-scheduled-that-ca