Optional: Automate It Nightly for Key Queries

You can maintain a list of important SQL_IDs in a table and loop through them in a scheduled job. Here’s how to automate nightly baseline logging for important SQL statements by maintaining a list of SQL_IDs and looping through them in a job.