Can I schedule an XEvent Profile to run at a specified date/time/duration?
No, this is not possible at present.
SQL XEvent Profiler can filter the displayed results for specified dates/times that events occurred, but SQL XEvent Profiler can only capture events that occur while it is running.
Windows Task Scheduler can start SQL XEvent Profiler at a specified date/time, but SQL XEvent Profiler needs user interaction (New > Connect To Server > Run) before it starts capturing events. SQL XEvent Profiler does not have command-line options to bypass such user interaction.
We added this to our list of feature requests for possible future versions of SQL XEvent Profiler.
Powered by IDERA