Our Trigger History Retention is currently set to 730 days (to high). Does anyone have a query I can run against the database to delete up to the last 30 or 60 day?. I like to only keep 30 days... What is the db table name that hold this information?
I haven't worked on this type of query, but I believe the trigger history can be found on trgtskrun table. Or maybe just do a mass update on the expiration field, and let Tidal handle the deletion.
HTH,
Derrick Au
Learn, share, save
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
