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?
I think only sqlserver.rpc_completed event will give you complete SQL command including parameter values.