Been trying out a set of reports on a number of databases, at some point i had to stop/delete a running/queued report and the queue positioning was managed well enough, one challenge though i noticed is as i stopped/deleted a running report request. the next queued report took forever(couldn’t wait enough) to start running.
I unfortunately ran out of time chocked the process and had to run on other backups, i plan to reinvestigate this as soon as circumstances allow me in the future. just wanted to leave this here so that in-case someone experiences or ever experienced this, this enough smoke would trigger a thorough investigation and extinction.
CC @mseaton