Scheduling SSRS reports using an external scheduling package

We use a scheduling package to coordinate the scheduling of our batch
processes on most of our systems. Is there a way to trigger the
running of an SSRS report this way? And, what the specifics of what
is takes with some examples of how and what needs to be interfaced?
Thanks,On Sep 17, 12:49 pm, thill...@.steelcase.com wrote:
> We use a scheduling package to coordinate the scheduling of our batch
> processes on most of our systems. Is there a way to trigger the
> running of an SSRS report this way? And, what the specifics of what
> is takes with some examples of how and what needs to be interfaced?
> Thanks,
You can look into the rs.exe utility. Also, you might want to consider
calling a URL similar to this one to obtain the physical report file
and then attach it to an email. You can do this in ASP.NET (attaching
the file to an email, streaming the report file directly from an
HTTPRequest of the URL below), etc. It's up to you're preference and
expertise.
http://ServerX/reportserver?/Directory/ReportName&rs:Command=Render&Param1=Param1Value&rs:Format=PDF
Format:
http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Render&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Scheduling reports to run

Is there a way to schedule reports to run on a specif day and time and save them to excel files?

Hello John,

Yes, of course you can.

Open Report Manager. (http://ServerName/Reports) and drill down to your report you want to schedule. Click on the Properties tab from the tob and the Data Sources tab from the left. Verify that you connection is correct and select 'Credentials stored securely in the report server' and give it an account to run the report. Then go to the Subscriptions tab from the top and hit 'New Subscription'. If you want to save to Excel, then select 'Report Server File Share' and set your options. Down at the bottom, you can set the schedule of the report.

Hope this helps.

Jarret

|||Thanks, Jarret. That's easy enough.sql

scheduling reports to refresh

Hi all!
Is it possible to schedule reports to refresh overnight? Particularly if
they take a long time to return data - for example in business objects i
would normally schedule a report to refresh overnight via the broadcast
agent console...is the same thing at all possible in reporting services?
does RS have sheduling functionality?
many thanks
GregYes, it has extensive functionality in this area.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:5E5D3B2C-AE87-4ABB-8E84-469A51511863@.microsoft.com...
> Hi all!
> Is it possible to schedule reports to refresh overnight? Particularly if
> they take a long time to return data - for example in business objects i
> would normally schedule a report to refresh overnight via the broadcast
> agent console...is the same thing at all possible in reporting services?
> does RS have sheduling functionality?
> many thanks
> Greg|||ok.....anything further? lol
HOW DO I DO IT!!!
anyone'
"Bruce L-C [MVP]" wrote:
> Yes, it has extensive functionality in this area.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Greg" <Greg@.discussions.microsoft.com> wrote in message
> news:5E5D3B2C-AE87-4ABB-8E84-469A51511863@.microsoft.com...
> > Hi all!
> >
> > Is it possible to schedule reports to refresh overnight? Particularly if
> > they take a long time to return data - for example in business objects i
> > would normally schedule a report to refresh overnight via the broadcast
> > agent console...is the same thing at all possible in reporting services?
> > does RS have sheduling functionality?
> >
> > many thanks
> >
> > Greg
>
>|||It seemed like you just wondered if it was possible. I thought that maybe
you weren't using Reporting Services and were just making plans.
Anyway, a few of what you need to understand. Search in books online for
snapshot, schedule and history. Reading up on those things should get you
started. Here are a few links to get you rolling:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsmain/htm/rsc_ov_using_v1_4u43.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_catalog_v1_9zsm.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_scheduling_v1_2qgk.asp
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:593EBCB8-9CA6-42BB-994C-CFAB8F44495F@.microsoft.com...
> ok.....anything further? lol
> HOW DO I DO IT!!!
> anyone'
> "Bruce L-C [MVP]" wrote:
>> Yes, it has extensive functionality in this area.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Greg" <Greg@.discussions.microsoft.com> wrote in message
>> news:5E5D3B2C-AE87-4ABB-8E84-469A51511863@.microsoft.com...
>> > Hi all!
>> >
>> > Is it possible to schedule reports to refresh overnight? Particularly
>> > if
>> > they take a long time to return data - for example in business objects
>> > i
>> > would normally schedule a report to refresh overnight via the
>> > broadcast
>> > agent console...is the same thing at all possible in reporting
>> > services?
>> > does RS have sheduling functionality?
>> >
>> > many thanks
>> >
>> > Greg
>>

Scheduling Reports

Hello. I was wondering if this was possible:

The first report (rpt A) has an sql database field that has a number 1 and number 0. 1 refers to reports to be scheduled and 0 means no reports are scheduled or have been scheduled already.

I want my report to go and check this database field, so when it equals 1 it will trigger an event to schedule a second report (rpt B). Once scheduled, rpt A flags the database field to zero.

Is this possible? Please help.

Best regardsI am not sure what you meant
Add rpt B as a subreport in rpt A
Then goto format section where rpt B located and in the suppress option write this code
{rpt A Field}=0

Scheduling Reports

How are reporting services reports scheduled to run and email? I don't see
any links in the SQL Server Business Intelligence Development Studio. Are
there plug ins or something else from microsoft that could be missing? I have
SQL Server 2005 SP1 running on my PC (windows 2003). Any step by step
documentation?Reports are scheduled through Report Manager... Go to
http://<yourserver>/reports
Then select a report.
You should see a subscriptions tab, where you can schedule.
To schedule a report, the data source MUST use Credentials Stored Securely
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"dbach" wrote:
> How are reporting services reports scheduled to run and email? I don't see
> any links in the SQL Server Business Intelligence Development Studio. Are
> there plug ins or something else from microsoft that could be missing? I have
> SQL Server 2005 SP1 running on my PC (windows 2003). Any step by step
> documentation?
>

Scheduling Report Delivery to Printers

Hi,
Have any of you work with Extensions to schedule delivery of reports
directly to printers?
I played a little bit with the sample Delivery Extension provided by
Microsoft, I do not seem to get it to work.
Any ideas of how to schedule RS to print reports automatically?
ThanksThis is something I spent a lot of time on about a year ago without any
success.
The MS extensions I tried would almost work but it scaled the report just a
touch wrong and cut off text so it was of no use to me.
I would be very interested in solution myself.
"Jaraba" <Jaraba@.discussions.microsoft.com> wrote in message
news:E6E07910-4272-49C3-A3E9-86D6923B438B@.microsoft.com...
> Hi,
> Have any of you work with Extensions to schedule delivery of reports
> directly to printers?
> I played a little bit with the sample Delivery Extension provided by
> Microsoft, I do not seem to get it to work.
> Any ideas of how to schedule RS to print reports automatically?
> Thanks
>

Scheduling once per hour for part of a day

Hi!
I wonder if it is possible in any way to schedule reports to run every hour
each day between 0800 and 1700?
/MattiasSure, select the report from http://yourserver/reports, go to properties and
select "Render this report from an execution snapshot".
THen you may set the execution schedule as you wish..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mattias" <Mattias@.discussions.microsoft.com> wrote in message
news:D39C0FF0-5482-4FA4-9B9D-8AF54C44E60E@.microsoft.com...
> Hi!
> I wonder if it is possible in any way to schedule reports to run every
hour
> each day between 0800 and 1700?
> /Mattias|||I still can't see a way of scheduling the report to run once an hour during
just a part of the day as my question was.
I can schedule it to run once per hour 24 hours a day, but not just between
e.g. 0800 and 1700, or am I just dumb?
/Mattias
"Wayne Snyder" wrote:
> Sure, select the report from http://yourserver/reports, go to properties and
> select "Render this report from an execution snapshot".
> THen you may set the execution schedule as you wish..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Mattias" <Mattias@.discussions.microsoft.com> wrote in message
> news:D39C0FF0-5482-4FA4-9B9D-8AF54C44E60E@.microsoft.com...
> > Hi!
> >
> > I wonder if it is possible in any way to schedule reports to run every
> hour
> > each day between 0800 and 1700?
> >
> > /Mattias
>
>|||I answered your other post on this question.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"MattiasT" <MattiasT@.discussions.microsoft.com> wrote in message
news:846AF338-47C2-44B0-A97D-0BA6C01F0464@.microsoft.com...
> I still can't see a way of scheduling the report to run once an hour
during
> just a part of the day as my question was.
> I can schedule it to run once per hour 24 hours a day, but not just
between
> e.g. 0800 and 1700, or am I just dumb?
> /Mattias
> "Wayne Snyder" wrote:
> > Sure, select the report from http://yourserver/reports, go to properties
and
> > select "Render this report from an execution snapshot".
> > THen you may set the execution schedule as you wish..
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Mattias" <Mattias@.discussions.microsoft.com> wrote in message
> > news:D39C0FF0-5482-4FA4-9B9D-8AF54C44E60E@.microsoft.com...
> > > Hi!
> > >
> > > I wonder if it is possible in any way to schedule reports to run every
> > hour
> > > each day between 0800 and 1700?
> > >
> > > /Mattias
> >
> >
> >

Scheduling multiple reports at one time

Hi,

I need my reports to run at the 4rth day of every month. I have packs of reports, and typically upto 18 reports in a pack and these packs have to run on the 4rth of every month.

How can i schedule the 18 reports to run at the same time. I don't want to schedule a time for every report ,this is very laborious.Is there any option in SSRS for simulataneously scheduling of these reports?

Thanks

Hi,

You can achieve this functionality by using a Shared Schedule.

In the case the question is if you can assign the schedule to all reports at once, the answer is not by using the web interface, but you can create an script to do so.

In the case you're asking to chain the report processing (i.e.:start report 2 when report 1 is finished), you will need to revert to a script again.

HTH,

Jordi Rambla
MVP SQL Server (Reporting Services)
Certia - rambla informàtica (http://www.certia.net)
Solid Quality Learning (http://www.solidqualitylearning.com)

sql

Scheduling approach

We user SQL sever 2005, I have a reports runs very slow since big chunk
of data, I just want to run it once a day. This report has few
selections fields, for different people they want to see different
selection criteria, is there a way I can just schedule it once for wide
open selection and each person based on this generic report to narrow
down to their own small set of data? thanksI use email to notify the end user for the "new" genereated report, but
why each time the user click the link, instead of giving the snapshot,
the link do the RE-Generat report? how do i let user only see the
snapshot, it is a big report.|||On the report options, set the execution to execute from a snapshot and set
the snapshot creation for a quiet time to avoid impacting OLTP. Then set up a
subscription to run when content is refreshed (available only for snapshot
reports). You will need to set up default parameters, but if chosen to return
NULL data, you effectively get an email with a notice of report content
update with a dummy report attached.
"Wang Xiaoning" wrote:
> I use email to notify the end user for the "new" genereated report, but
> why each time the user click the link, instead of giving the snapshot,
> the link do the RE-Generat report? how do i let user only see the
> snapshot, it is a big report.
>sql

Scheduling

Hi there
I have uploaded some reports to our reporting services server, however I
want to be able to have them emailed to clients outside the network at the
end of each week,
Can you explain how to do this?
Regards
TimYou can set up a subscription via the subscription tab in Report Manager.
If you are using the Enterprise edition of Report Server you will want to
take a look into Data Driven Subscriptions.
You can find more information here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
Here is information of Data Driven Subscriptions:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_manager_v1_9syq.asp
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"catalyst" <catalyst@.discussions.microsoft.com> wrote in message
news:E5DFB9D6-5DD1-4F51-9A2A-E405BD343D84@.microsoft.com...
> Hi there
> I have uploaded some reports to our reporting services server, however I
> want to be able to have them emailed to clients outside the network at the
> end of each week,
> Can you explain how to do this?
> Regards
> Tim

Scheduled weekly reports

I am trying to create a Job that will run a stored procedure i have scripted
and the email the the results to certain managers in my company for analysis
purposes. The procedure is fine i was just wondering how i would get the
results formatted and into an email. Do i use the SQL Mail?hi
did u see xp_sendmail
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.SQLResource.com/
---
"A.B." wrote:

> I am trying to create a Job that will run a stored procedure i have script
ed
> and the email the the results to certain managers in my company for analys
is
> purposes. The procedure is fine i was just wondering how i would get the
> results formatted and into an email. Do i use the SQL Mail?|||"A.B." <AB@.discussions.microsoft.com> wrote in message
news:4C34B83A-C86E-4031-ACEF-05B4F02B0326@.microsoft.com...
>I am trying to create a Job that will run a stored procedure i have
>scripted
> and the email the the results to certain managers in my company for
> analysis
> purposes. The procedure is fine i was just wondering how i would get the
> results formatted and into an email. Do i use the SQL Mail?
No, you use reporting services.|||Do both: use SQL Mail to send a message that the report is ready, but use SQ
L
Reporting Services for the actual report.
Why would you need to send a large amount of data through e-mail? Don't they
get enough spam anyway? ;)
ML|||"ML" <ML@.discussions.microsoft.com> wrote in message
news:7303024C-CB3B-4273-9D76-24D9C962D9BC@.microsoft.com...
> Do both: use SQL Mail to send a message that the report is ready, but use
> SQL
> Reporting Services for the actual report.
Or you could use Reporting Services to both render and send notification via
email.

Scheduled reports not working - service account

Hi
I'm just getting my feet wet with Scheduled reports in SSRS2005, and have
hit a snag...
The schedule is not working, and when I check the job history on SQL Server
I find the message:
'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK
SERVICE'. The step failed.
I find if I go into Management Studio, I can change the NETWORK SERVICE to a
domain user account, and everything works - but then I can't change the
subscription properties from Report Manager.
SQL Server & SSRS are both running on Windows Server 2003 under a domain
account, and the data/SSRS connection points to an SQL Server 2000 Database
on a different server in the domain.
Any ideas? I've gone through the security recommendations and still can't
find a solution.
Regards
GrantHi
Don't worry about responding to this one - I figured it out...
Fixed it by setting everything to use the NetworkService account, except for
the SQL Agent - I found one of my mistakes was changing the account from the
Service Manager, instead of the SQL Server Configuration Manager.
Anyway - all is well and reports are running as scheduled.
Thanks
Grant
"Grant Morgan" <grantmorgan@.noemail.noemail> wrote in message
news:ujq4Jos3GHA.696@.TK2MSFTNGP03.phx.gbl...
> Hi
> I'm just getting my feet wet with Scheduled reports in SSRS2005, and have
> hit a snag...
> The schedule is not working, and when I check the job history on SQL
> Server I find the message:
> 'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK
> SERVICE'. The step failed.
> I find if I go into Management Studio, I can change the NETWORK SERVICE to
> a domain user account, and everything works - but then I can't change the
> subscription properties from Report Manager.
> SQL Server & SSRS are both running on Windows Server 2003 under a domain
> account, and the data/SSRS connection points to an SQL Server 2000
> Database on a different server in the domain.
> Any ideas? I've gone through the security recommendations and still can't
> find a solution.
> Regards
> Grant
>
>

Scheduled reports not running

Hi
We having problems running our scheduled reports.
A domain admin had originally scheduled them under her network username
which as i said had domain admin rights. Those domain rights where taken away
from her username and then we created a sql user name to run the report,
since then the scheduled reports do not run and not quite sure where to look.
Reporting the username on sql has accessadmin rights and public rights on
the reporting databases, does anyone have an inkling of what might be going
on?
I have checked the log but it doesn't give any errors it just says this
aspnet_wp!library!1dc!10/21/2005-08:14:33:: i INFO: Call to
GetPermissions:/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!library!1dc!10/21/2005-08:14:33:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1dc!10/21/2005-08:14:34:: i INFO: Call to RenderFirst(
'/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:14:34:: i INFO: From cache live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!library!1dc!10/21/2005-08:14:34:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!1dc!10/21/2005-08:14:34:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:14:34:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:14:45:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:14:45:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:45:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:45:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:14:45:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:14:45:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:14:48:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:14:48:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:49:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:49:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:14:49:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:14:49:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:14:53:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:14:53:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:53:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:53:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:14:53:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:14:53:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:14:57:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:14:57:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:57:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:57:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:14:57:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:14:57:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:15:00:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:15:00:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:00:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:00:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:15:00:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:15:00:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:15:04:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:15:04:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:04:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:04:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:15:04:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:15:04:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:15:08:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:15:08:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:08:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:08:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:15:08:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:15:08:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:15:18:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:15:18:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:18:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:18:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:15:18:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:15:18:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
basically it looks as though the report has run' but i know it hasn't.Did you check all three logs, keep in mind there may be multiple logs for the
same day:
- ReportServerWebApp
- ReportServerService
- ReportServer
Are there any errors in any of these at the time the subscription was
supposed to run?
Also, does the log on account running the ReportServer service a Domain
Admin account? It needs to be able to look up account credentials for RS
users on your network.
And, is your ReportServer instance configured to work with Windows
authentication, SQL Authentication or both?
Thanks.
bhc
"Vanessa" wrote:
> Hi
> We having problems running our scheduled reports.
> A domain admin had originally scheduled them under her network username
> which as i said had domain admin rights. Those domain rights where taken away
> from her username and then we created a sql user name to run the report,
> since then the scheduled reports do not run and not quite sure where to look.
> Reporting the username on sql has accessadmin rights and public rights on
> the reporting databases, does anyone have an inkling of what might be going
> on?
> I have checked the log but it doesn't give any errors it just says this
>
> aspnet_wp!library!1dc!10/21/2005-08:14:33:: i INFO: Call to
> GetPermissions:/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!library!1dc!10/21/2005-08:14:33:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1dc!10/21/2005-08:14:34:: i INFO: Call to RenderFirst(
> '/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:14:34:: i INFO: From cache live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!library!1dc!10/21/2005-08:14:34:: i INFO: Initializing
> EnableExecutionLogging to 'True' as specified in Server system properties.
> aspnet_wp!webserver!1dc!10/21/2005-08:14:34:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:14:34:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:14:45:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:14:45:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:45:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:45:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:14:45:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:14:45:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:14:48:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:14:48:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:49:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:49:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:14:49:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:14:49:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:14:53:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:14:53:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:53:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:53:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:14:53:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:14:53:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:14:57:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:14:57:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:57:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:57:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:14:57:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:14:57:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:15:00:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:15:00:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:00:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:00:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:15:00:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:15:00:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:15:04:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:15:04:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:04:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:04:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:15:04:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:15:04:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:15:08:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:15:08:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:08:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:08:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:15:08:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:15:08:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:15:18:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:15:18:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:18:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:18:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:15:18:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:15:18:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> basically it looks as though the report has run' but i know it hasn't.
>

Scheduled Reports Not Being Sent Out

I have several scheduled reports that have been running every morning and being emailed out to many recipients. One day it all stopped. There are no error messages. It just doesn't work any more.

I have tried re-deploying them to the report server and rescheduling the jobs but they still don't run.

There are no error messages in the Reporting services log?

Is this RS 2005? I had a problem recently with the SMTP server name specified in the RS Config Tool, I had to use the IP address of the SMTP server rather than the name of it and it fixed the problem. It was something to do with a DNS issue we had.

Might be worth a try.

|||

Hi,

Same problem I have now as you had, I wonder how did you solve your problem.

Please advise,

Frank

|||There has to be some information in the error log of SQL Server Reporting services (stack trace or an informal message). Please post that here.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||All subscription schedules become SQL Agent jobs. You should look in SQL Agent to see if there is an issue with the jobs firing.

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

Scheduled reports

I have set up reports to be generated hourly and emailed to me, however the report will run for a few hours and then stop. I have checked the schedule and made sure there is not expiration date. My question is: Is ther anyway is can get report status if the report errors with the error message so that i can track this issue?

Any assistance here would be greatly appreciated.

Regards,
Hi,
As far as I experienced there are few places where we can check the status of a scheduled report.
One of them is the reports' subscriptions tab ( http://reportserver/Reports/Pages/Report.aspx ) when you open the properties page for that report on the reports directory. There exists a status column.
Also when you edit the subscription for that report again on the same page above, you will be redirected to http://reportserver/Reports/Pages/SubscriptionProperties.aspx page. There is the schedule name which is used by the SQL Server instance where the ReportServer databases are installed.

If you go open Jobs list by using SQL Server Enterprise Manager, you can see the job in the list. Again detailed status information for that job can be seen there. Or by opening the job history screen from the context menu.
Or you can check the Event Viewer for the ReportServer service specific messages.
Eralper|||

Hi:

I set up a report that pulls data from the ExecutionLog table from the ReportServer DB.

If there is an error, it can be read from C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles

Regs,

Perry

Scheduled reports

I have set up reports to be generated hourly and emailed to me, however the report will run for a few hours and then stop. I have checked the schedule and made sure there is not expiration date. My question is: Is ther anyway is can get report status if the report errors with the error message so that i can track this issue?

Any assistance here would be greatly appreciated.

Regards,
Hi,
As far as I experienced there are few places where we can check the status of a scheduled report.
One of them is the reports' subscriptions tab ( http://reportserver/Reports/Pages/Report.aspx ) when you open the properties page for that report on the reports directory. There exists a status column.
Also when you edit the subscription for that report again on the same page above, you will be redirected to http://reportserver/Reports/Pages/SubscriptionProperties.aspx page. There is the schedule name which is used by the SQL Server instance where the ReportServer databases are installed.
If you go open Jobs list by using SQL Server Enterprise Manager, you can see the job in the list. Again detailed status information for that job can be seen there. Or by opening the job history screen from the context menu.
Or you can check the Event Viewer for the ReportServer service specific messages.
Eralper|||

Hi:

I set up a report that pulls data from the ExecutionLog table from the ReportServer DB.

If there is an error, it can be read from C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles

Regs,

Perry

Scheduled report printing?

Hi,
We are running SQL Server 2000 and would like to have a series of reports
print out each morning without user intervention. What would be the best
way to accomplish this? If this is not the correct news group for this type
of question please direct me to the correct one.
Thanks in advance,
LinnThanks Igor, that's an interesting article. Too bad I don't have Visual
Studio, or Reporting Services for that matter. I also just noticed that the
article is for SQL Server 2005, we are using SQL Server 2000 still, wonder
if it would work for our version too.
I wonder if a third party software package like Crystal Reports would offer
this option?
Thanks,
Linn
"Igor Taranov -- MSFT" <IgorTaranovMSFT@.discussions.microsoft.com> wrote in
message news:888959B3-CAFB-4122-9F07-3070B15C13B4@.microsoft.com...
> See http://msdn2.microsoft.com/en-us/library/ms160778.aspx
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Linn Kubler" wrote:
>> Hi,
>> We are running SQL Server 2000 and would like to have a series of reports
>> print out each morning without user intervention. What would be the best
>> way to accomplish this? If this is not the correct news group for this
>> type
>> of question please direct me to the correct one.
>> Thanks in advance,
>> Linn
>>|||Has anyone actually got the Sample Printer Delivery Extension to work on a
Reporting Server?
"Igor Taranov -- MSFT" wrote:
> Linn,
> SQL Server Reporting Services 2005 can be installed on SQL 2000, and printer
> delivery should work fine.
> -Igor
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Linn Kubler" wrote:
> > Thanks Igor, that's an interesting article. Too bad I don't have Visual
> > Studio, or Reporting Services for that matter. I also just noticed that the
> > article is for SQL Server 2005, we are using SQL Server 2000 still, wonder
> > if it would work for our version too.
> >
> > I wonder if a third party software package like Crystal Reports would offer
> > this option?
> >
> > Thanks,
> > Linn
> >
> > "Igor Taranov -- MSFT" <IgorTaranovMSFT@.discussions.microsoft.com> wrote in
> > message news:888959B3-CAFB-4122-9F07-3070B15C13B4@.microsoft.com...
> > > See http://msdn2.microsoft.com/en-us/library/ms160778.aspx
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > >
> > >
> > > "Linn Kubler" wrote:
> > >
> > >> Hi,
> > >>
> > >> We are running SQL Server 2000 and would like to have a series of reports
> > >> print out each morning without user intervention. What would be the best
> > >> way to accomplish this? If this is not the correct news group for this
> > >> type
> > >> of question please direct me to the correct one.
> > >>
> > >> Thanks in advance,
> > >> Linn
> > >>
> > >>
> > >>
> >
> >
> >

Scheduled Emailing of SRS Reports

I've searched this forum for the subject of this post, and have
wandered into long discussions involving byzantine XML into config
files, and complicated class object creation, and I hope this is
mistaken... but is there truly no easy way to simply schedule a report
to be sent via email? I'm hoping for a nice wizard that lets me (a)
pick a report, (b) pick a schedule, and (c) select my recipients...
If there is such a wizard (or, I guess even more importantly if there
isn't), does anybody have a step by step instruction set to get this
to work? Or should I just tell my clients "never mind"...
Many thanks,
DaveA subscription for a report does all this. It is almost a wizard. If
you haven't read up on this, check it out. One issue though is that I
believe that subscriptions require the Enterprise edition.
Neil
On Feb 7, 3:33 pm, "Dave Carr" <d...@.vscrm.com> wrote:
> I've searched this forum for the subject of this post, and have
> wandered into long discussions involving byzantine XML into config
> files, and complicated class object creation, and I hope this is
> mistaken... but is there truly no easy way to simply schedule a report
> to be sent via email? I'm hoping for a nice wizard that lets me (a)
> pick a report, (b) pick a schedule, and (c) select my recipients...
> If there is such a wizard (or, I guess even more importantly if there
> isn't), does anybody have a step by step instruction set to get this
> to work? Or should I just tell my clients "never mind"...
> Many thanks,
> Dave|||Subscriptions are in standard, data driven subscriptions require Enterprise.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<neilgould@.gmail.com> wrote in message
news:1170887444.293038.210870@.k78g2000cwa.googlegroups.com...
>A subscription for a report does all this. It is almost a wizard. If
> you haven't read up on this, check it out. One issue though is that I
> believe that subscriptions require the Enterprise edition.
> Neil
> On Feb 7, 3:33 pm, "Dave Carr" <d...@.vscrm.com> wrote:
>> I've searched this forum for the subject of this post, and have
>> wandered into long discussions involving byzantine XML into config
>> files, and complicated class object creation, and I hope this is
>> mistaken... but is there truly no easy way to simply schedule a report
>> to be sent via email? I'm hoping for a nice wizard that lets me (a)
>> pick a report, (b) pick a schedule, and (c) select my recipients...
>> If there is such a wizard (or, I guess even more importantly if there
>> isn't), does anybody have a step by step instruction set to get this
>> to work? Or should I just tell my clients "never mind"...
>> Many thanks,
>> Dave
>

Schedule your own reports

Can i in reporting services 200 create some application that loops through and generates the reporting services report and email to the recepiant I specify in the mini application. I do not want to schedule the job in reporting services as the person receiving the email will be different each time based on criteria. If anyone knows the syntax to generate a report and pass the parameters, email and format it would be much appreciated

Lee,

You can using the Reporting Service Web API or you can write .NET code to generate our report, connect with System.web.mail. to email it, and you can use the render of the response to give for different type whether it's HTML, EXCEL and etc...

Here's a URL to get you going:

http://www.codeproject.com/sqlrs/SQLRSViewer.asp