Canvas LMS rake task to return the number of queued delayed jobs

gistfile1.rb

namespace :ocadu do
  "Returns the number of delayed jobs in the queue"
  task :job_count => :environment do
    puts Delayed::Job.where("run_at < UTC_TIMESTAMP() AND locked_at is null").count
  end
end

Note that this will include the count of currently running jobs and jobs scheduled in the future as well, which could throw off your monitoring if there are a significant number of them. Here @ Instructure we use this SQL query to monitor the job queue size:

select count(1) from delayed_jobs where run_at < now() and locked_at is null;

Thanks Brian!

BTW, I think for MySQL the query should be:

select count(1) from delayed_jobs where run_at < UTC_TIMESTAMP() and locked_at is null;