Menu
  • HOME
  • TAGS

How can I schedule an extended event to run at a specific time

sql-server-2012,extended-events

You can create the session at any moment using CREATE EVENT SESSION: this will only create the session, but won't start it. In your SQL Agent job you can start the session according to your schedule using this simple command: ALTER EVENT SESSION session_name ON SERVER STATE = start; ...

Capture passed parameter values in SQL Server extended sessions?

sql-server,extended-events

I think only sqlserver.rpc_completed event will give you complete SQL command including parameter values.