Print spooler failing to start up

The issue was related to a HP monitoring driver. Somehow this software got installed.  Maybe it got installed trying to extract a driver...
Reference:
http://support.microsoft.com/kb/947477

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