How SQL 2005 Report Server works

Nice blog (see Reference below) about how report server works and what the logs files are for.

Here are some queries that I use to check to see if jobs are stuck on our Report server:

use ReportServer

-- Jobs waiting to execute

select *
from event e
order by TimeEntered

-- Jobs that ARE executing

select n.processstart, n.notificationentered, n.deliveryextension, sch.scheduleid, sub.subscriptionid, sub.description, sub.laststatus, sub.lastruntime
from notifications n, schedule sch, subscriptions sub
where (n.subscriptionid = sub.subscriptionid) and (sch.eventdata = sub.subscriptionid)
order by n.notificationentered desc


Reference:
http://blogs.msdn.com/b/psssql/archive/2009/02/02/why-aren-t-my-subscriptions-working.aspx