Sql query behind "Global expiry" job

[Sofya]

Hi,

Does anybody can tell me the SQL query behind the "Global expiry" job? I want to have a dry run, just to see what I'm going to delete before I actually run the job.

I'd run it against my database to see the results. 

My Bamboo server version is 5.14.3.1, database is MS SQL. 

Thank you.

[Jeyanthan I]

It is a fairly complicated task.

You can listen to the SQL query that it generates by enabling this page - How to Enable Detailed SQL Logging. (there will be a lot of noise though)

If you have a valid license, you can download the source code and review the corresponding class by yourself or raise a support ticket with us.

Nevertheless, this sounds like a good feature request. I have raised one on your behalf. I encourage you to upvote it.

Preview option before we run Global expiry job manually