XF 2.1 Get deferred task count

[nrep]

We've got some backend software that monitors our XF installations, including a mechanism to alert us to when deferred tasks are waiting in the background (from XF1). We used to use this code to find out how many deferred tasks there were:

$deferredtasks = $db->fetchRow("SELECT COUNT(*) FROM xf_deferred WHERE manual_execute = 1");

However, this table no longer exists in XF2.1. Is there a way to get the deferred task count now? I've had a look at other tables, but can't see where the tasks could be stored.

Any help would be appreciated.

 

[nrep]

No sooner had I posted this, then I find the answer . The new table is xf_job for anyone else with the same problem!

 

[TickTackk]

\XF::app()->db()->fetchOne('SELECT COUNT(*) FROM xf_job WHERE manual_execute = 0')