Scheduled reports never run

I can run reports in Report Manager, but none of the subscriptions I set up
ever run. I have tried creating subscriptions that run both at a preset
time and according to a shared schedule. In the ReportServerService log
files, I see that polling of various types is initiated but nothing after
that. The Cleanup runs every 10 minutes but nothing elese does. See log
file below:
ReportingServicesService!resourceutilities!17c!6/23/2004-07:27:56:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 66723 seconds
ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO: Memory
stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
Initializing crypto as user: Proposion\Steve
ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO: Exporting
public key
ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO: Performing
sku validation
ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57:: EventPolling
polling service started
ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
NotificationPolling polling service started
ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!ef0!6/23/2004-07:27:57:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!e04!6/23/2004-07:27:57::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!f84!6/23/2004-07:27:57:: Polling started
ReportingServicesService!library!17c!6/23/2004-07:46:09:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!17c!6/23/2004-07:56:06:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!17c!6/23/2004-08:06:06:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
Shouldn't there at least be an indication that events are triggered and why
reports can't run?
Interestingly, if I look at the Shared Schedules in Report Manager and the
"Next Run" shows the expected time (which has now elapsed) but the "Last
Run" still says "Never Run".
I have tries restarting SQLSERVERAGENT and Reporting Service services, as
well as completely rebooting.
Thanks for your help!Is there an error listed on the job in JOBS on the SQL server? And if so what are they?
"Stephen Walch" <swalch@.proposion.com> wrote in message news:eqzhZkTWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> I can run reports in Report Manager, but none of the subscriptions I set up
> ever run. I have tried creating subscriptions that run both at a preset
> time and according to a shared schedule. In the ReportServerService log
> files, I see that polling of various types is initiated but nothing after
> that. The Cleanup runs every 10 minutes but nothing elese does. See log
> file below:
> ReportingServicesService!resourceutilities!17c!6/23/2004-07:27:56:: i INFO:
> Reporting Services starting SKU: Developer
> ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 66723 seconds
> ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO: Memory
> stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
> Initializing crypto as user: Proposion\Steve
> ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO: Performing
> sku validation
> ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO: Importing
> existing encryption key
> ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57:: EventPolling
> polling service started
> ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
> NotificationPolling polling service started
> ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57:: SchedulePolling
> polling service started
> ReportingServicesService!dbpolling!ef0!6/23/2004-07:27:57:: EventPolling
> heartbeat thread started.
> ReportingServicesService!dbpolling!e04!6/23/2004-07:27:57::
> NotificationPolling heartbeat thread started.
> ReportingServicesService!dbpolling!f84!6/23/2004-07:27:57:: Polling started
> ReportingServicesService!library!17c!6/23/2004-07:46:09:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!17c!6/23/2004-07:56:06:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!17c!6/23/2004-08:06:06:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
>
> Shouldn't there at least be an indication that events are triggered and why
> reports can't run?
> Interestingly, if I look at the Shared Schedules in Report Manager and the
> "Next Run" shows the expected time (which has now elapsed) but the "Last
> Run" still says "Never Run".
> I have tries restarting SQLSERVERAGENT and Reporting Service services, as
> well as completely rebooting.
> Thanks for your help!
>|||I see no files listed in the "C:\Program Files\Microsoft SQL
Server\MSSQL\JOBS" directory, if that is what you mean. (Sorry I am rather
new to SQL server.)
-Steve
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:e%23btTsTWEHA.3120@.TK2MSFTNGP12.phx.gbl...
> Is there an error listed on the job in JOBS on the SQL server? And if so
what are they?
> "Stephen Walch" <swalch@.proposion.com> wrote in message
news:eqzhZkTWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > I can run reports in Report Manager, but none of the subscriptions I set
up
> > ever run. I have tried creating subscriptions that run both at a preset
> > time and according to a shared schedule. In the ReportServerService log
> > files, I see that polling of various types is initiated but nothing
after
> > that. The Cleanup runs every 10 minutes but nothing elese does. See log
> > file below:
> >
> > ReportingServicesService!resourceutilities!17c!6/23/2004-07:27:56:: i
INFO:
> > Reporting Services starting SKU: Developer
> > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > Running Requests Scavenger timer enabled: Cycle: 60 seconds
> > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > Running Requests DB timer enabled: Cycle: 60 seconds
> > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > Execution Log Entry Expiration timer enabled: Cycle: 66723 seconds
> > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
Memory
> > stats update timer enabled: Cycle: 60 seconds
> > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
> > Initializing crypto as user: Proposion\Steve
> > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
Exporting
> > public key
> > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
Performing
> > sku validation
> > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
Importing
> > existing encryption key
> > ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
EventPolling
> > polling service started
> > ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
> > NotificationPolling polling service started
> > ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
SchedulePolling
> > polling service started
> > ReportingServicesService!dbpolling!ef0!6/23/2004-07:27:57:: EventPolling
> > heartbeat thread started.
> > ReportingServicesService!dbpolling!e04!6/23/2004-07:27:57::
> > NotificationPolling heartbeat thread started.
> > ReportingServicesService!dbpolling!f84!6/23/2004-07:27:57:: Polling
started
> > ReportingServicesService!library!17c!6/23/2004-07:46:09:: i INFO:
Cleaned 0
> > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > chunks, 0 running jobs
> > ReportingServicesService!library!17c!6/23/2004-07:56:06:: i INFO:
Cleaned 0
> > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > chunks, 0 running jobs
> > ReportingServicesService!library!17c!6/23/2004-08:06:06:: i INFO:
Cleaned 0
> > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > chunks, 0 running jobs
> >
> >
> > Shouldn't there at least be an indication that events are triggered and
why
> > reports can't run?
> >
> > Interestingly, if I look at the Shared Schedules in Report Manager and
the
> > "Next Run" shows the expected time (which has now elapsed) but the "Last
> > Run" still says "Never Run".
> >
> > I have tries restarting SQLSERVERAGENT and Reporting Service services,
as
> > well as completely rebooting.
> >
> > Thanks for your help!
> >
> >
>|||If you go into Enterprise Manager and then:
Management -> SQL Server Agent -> Jobs there will be a list of all the jobs on your server (SQL Server Agent is like a daemon that
runs in the backgroup and runs timed tasks on the server, this is what reporting services uses to kick off reports that are on a
schedule)
One you see all the jobs you will find out that all your reporting services schedules are a mixture of letters and numbers. If you
look in the "Last Run Status" column you should see one with "Failed" (You can sort out the list by clicking on the "category" title
and looking where "Report Server" is entered. Right click on your failed job and choose "View job History". Then check the "Show
step details" box on the top right of the dialog box.
You can then click on the steps and get the server messages for that step (if any). Any error message information will be stored
there.
"Stephen Walch" <swalch@.proposion.com> wrote in message news:%23Jb%23yAVWEHA.3944@.tk2msftngp13.phx.gbl...
> I see no files listed in the "C:\Program Files\Microsoft SQL
> Server\MSSQL\JOBS" directory, if that is what you mean. (Sorry I am rather
> new to SQL server.)
> -Steve
> "Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
> news:e%23btTsTWEHA.3120@.TK2MSFTNGP12.phx.gbl...
> > Is there an error listed on the job in JOBS on the SQL server? And if so
> what are they?
> >
> > "Stephen Walch" <swalch@.proposion.com> wrote in message
> news:eqzhZkTWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > > I can run reports in Report Manager, but none of the subscriptions I set
> up
> > > ever run. I have tried creating subscriptions that run both at a preset
> > > time and according to a shared schedule. In the ReportServerService log
> > > files, I see that polling of various types is initiated but nothing
> after
> > > that. The Cleanup runs every 10 minutes but nothing elese does. See log
> > > file below:
> > >
> > > ReportingServicesService!resourceutilities!17c!6/23/2004-07:27:56:: i
> INFO:
> > > Reporting Services starting SKU: Developer
> > > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > > Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> > > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > > Running Requests Scavenger timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > > Running Requests DB timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > > Execution Log Entry Expiration timer enabled: Cycle: 66723 seconds
> > > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> Memory
> > > stats update timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
> > > Initializing crypto as user: Proposion\Steve
> > > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
> Exporting
> > > public key
> > > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
> Performing
> > > sku validation
> > > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
> Importing
> > > existing encryption key
> > > ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
> EventPolling
> > > polling service started
> > > ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
> > > NotificationPolling polling service started
> > > ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
> SchedulePolling
> > > polling service started
> > > ReportingServicesService!dbpolling!ef0!6/23/2004-07:27:57:: EventPolling
> > > heartbeat thread started.
> > > ReportingServicesService!dbpolling!e04!6/23/2004-07:27:57::
> > > NotificationPolling heartbeat thread started.
> > > ReportingServicesService!dbpolling!f84!6/23/2004-07:27:57:: Polling
> started
> > > ReportingServicesService!library!17c!6/23/2004-07:46:09:: i INFO:
> Cleaned 0
> > > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > > chunks, 0 running jobs
> > > ReportingServicesService!library!17c!6/23/2004-07:56:06:: i INFO:
> Cleaned 0
> > > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > > chunks, 0 running jobs
> > > ReportingServicesService!library!17c!6/23/2004-08:06:06:: i INFO:
> Cleaned 0
> > > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > > chunks, 0 running jobs
> > >
> > >
> > > Shouldn't there at least be an indication that events are triggered and
> why
> > > reports can't run?
> > >
> > > Interestingly, if I look at the Shared Schedules in Report Manager and
> the
> > > "Next Run" shows the expected time (which has now elapsed) but the "Last
> > > Run" still says "Never Run".
> > >
> > > I have tries restarting SQLSERVERAGENT and Reporting Service services,
> as
> > > well as completely rebooting.
> > >
> > > Thanks for your help!
> > >
> > >
> >
> >
>sql