Scheduling SQL Server 2005 report server

I'm looking a way to schedule a report to be generated in pre-define time and push it out to my users through email or file share any format (excell, Word, etc). Any help would be greatly appreciated.

When you view the report in a browser you'll see four tabs - View, Properties, History, Subscriptions. Create a new subscription and then enter the recipient (actual email address required) and select the Render Format as Excel, PDF, Web Archive etc. You can also set the date, time and frequency of the subscription.

Hope this helps,

Aidan

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 Report to render in to PDF format

Hi,
I have a report with 25 subreports which needs to generate one pdf file on
schedule basis (ie. schedule report to render in to PDF format based on some
time and date setting).
Is there any way of doing this?
Thanks in advance for the helper.
Regards.
AnithaYou need to subscribe to the report. As part of the subscription parameters
you can define the schedule of when you want the report to be automatically
generated.
Keep in mind that you have to also define a dafault value for each parameter
in your report.
Hope this helps,
Tigan
"Anitha Naidu" wrote:
> Hi,
> I have a report with 25 subreports which needs to generate one pdf file on
> schedule basis (ie. schedule report to render in to PDF format based on some
> time and date setting).
> Is there any way of doing this?
> Thanks in advance for the helper.
> Regards.
> Anitha
>

scheduling report for first weekday of each month

I'm pretty new to this, so could someone tell me if this
is possible? and if so, how?
thanksThis particular schedule is not supported by RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"barmanvarn" <anonymous@.discussions.microsoft.com> wrote in message
news:b83401c48921$b44bd050$a401280a@.phx.gbl...
> I'm pretty new to this, so could someone tell me if this
> is possible? and if so, how?
> thankssql

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 outside SRS

Hello All!
I have a requirement to set a schedule to run a report on the Tuesday
following the last Saturday of the month. It appears that this is not
possible via the Web UI so I hear I need to schedule it outside SRS. Oh yeah
and to make it more complex, if the Tuesday in in the new month, quarter, or
year then the parameter should select the previous month, quarter, or year
not the default of current month, current quarter, or current year. I think
the last part can easily be handled by getting the parameter values from the
date of the last saturday of the month, which would always give you the
correct month for month end reporting no matter if the next Tues is in the
next month or not.
what I need is the syntax for defining the parameters and rendering the
report. I would also like to specify a network drive where it can be
archived, email a link to an audience, and save a snapshot in history.
Can someone please help me with this? If not all then parts would be
appreciated!!!
AnthonyI am in the same situation. Were you able to resolve this?
--
---
Yes, I searched first :)
"anthonysjo" wrote:
> Hello All!
> I have a requirement to set a schedule to run a report on the Tuesday
> following the last Saturday of the month. It appears that this is not
> possible via the Web UI so I hear I need to schedule it outside SRS. Oh yeah
> and to make it more complex, if the Tuesday in in the new month, quarter, or
> year then the parameter should select the previous month, quarter, or year
> not the default of current month, current quarter, or current year. I think
> the last part can easily be handled by getting the parameter values from the
> date of the last saturday of the month, which would always give you the
> correct month for month end reporting no matter if the next Tues is in the
> next month or not.
> what I need is the syntax for defining the parameters and rendering the
> report. I would also like to specify a network drive where it can be
> archived, email a link to an audience, and save a snapshot in history.
> Can someone please help me with this? If not all then parts would be
> appreciated!!!
> Anthony
>|||Yes. Here is what you do. Create a subscription or a shared schedule but
set it to run only once and make it in the past. This will create a Schedule
ID in the database that you can reference later. Then open the Report Server
Database and return all rows for either the Schedules or Subcriptions table
depending on what you created. Copy the Schdule ID out of the table and make
note of the Event Type.
Now that you have this you can use the following code to fire the report
manually:
exec ReportServer.dbo.AddEvent
@.EventType='SharedSchedule', --Enter the event type here from the schedule
table in ReportServer Database
@.EventData='29C3FF88-D0D4-4B8A-A5D3-55DCBA8C215D' --Enter the subscription
ID here from the schedule table in ReportServer Database
I put this code inside the following stored procedure that is executed every
tuesday by a SQL job. If the @.myoutput date = Getdate then it executes the
code above otherwise it does nothing.
CREATE PROC dbo.MONTH_END_SCHEDULE as
--Declare variables
declare @.myoutputdate datetime
declare @.mydate datetime
declare @.minus int
declare @.TuesdayFound char(1)
declare @.subject varchar (255)
--set variables
set @.TuesdayFound='N'
--seed the date with the last day of the month
set
@.mydate=dateadd(dd,-1,convert(datetime,convert(varchar(2),datepart(mm,dateadd(mm,1,getdate())))+'/1/'+
convert(varchar(4),datepart(yy,dateadd(mm,1,getdate())))))
--a variable to backwards through the days of the month
set @.minus=0
WHILE @.TuesdayFound = 'N'
BEGIN
if datepart(dw,dateadd(dd,(@.minus*-1),@.mydate))=7 -- Find Last Saturday
BEGIN
set @.myoutputdate=dateadd(dd, 3,(dateadd(dd,(@.minus*-1),@.mydate))) --This
will add 3 days to the last Saturday
set @.TuesdayFound = 'Y'
END
set @.minus=@.minus+1
END
print @.myoutputdate
if datepart(dy,(getdate()))=datepart(dy,(@.myoutputdate))
BEGIN
exec ReportServer.dbo.AddEvent
@.EventType='SharedSchedule', --Enter the event type here from the schedule
table in ReportServer Database
@.EventData='29C3FF88-D0D4-4B8A-A5D3-55DCBA8C215D' --Enter the subscription
ID here from the schedule table in ReportServer Database
PRINT datename(mm, @.mydate)+ ' ' + datename(yyyy, @.mydate)+ ' Reports Fired '
SET @.subject = datename(mm, @.mydate)+ ' ' + datename(yyyy, @.mydate)+ ' Month
End reports are ready for viewing '
Exec master..xp_sendmail
@.recipients = 'someone@.somewhere.com',
@.copy_recipients = 'someone@.somewhere.com',
@.subject = @.subject,
@.message = 'Month End reports are now available via reporting services.
You can click on the link below and you will be taken directly to the
Month-End reports folder where you may choose to view the most recient
reports or view the history for archived reports.
http://localhost/Reports
If you have any questions please send an email to
someone@.somewhere.com'
END
GO
"Kmistic" wrote:
> I am in the same situation. Were you able to resolve this?
> --
> ---
> Yes, I searched first :)
>
> "anthonysjo" wrote:
> > Hello All!
> >
> > I have a requirement to set a schedule to run a report on the Tuesday
> > following the last Saturday of the month. It appears that this is not
> > possible via the Web UI so I hear I need to schedule it outside SRS. Oh yeah
> > and to make it more complex, if the Tuesday in in the new month, quarter, or
> > year then the parameter should select the previous month, quarter, or year
> > not the default of current month, current quarter, or current year. I think
> > the last part can easily be handled by getting the parameter values from the
> > date of the last saturday of the month, which would always give you the
> > correct month for month end reporting no matter if the next Tues is in the
> > next month or not.
> >
> > what I need is the syntax for defining the parameters and rendering the
> > report. I would also like to specify a network drive where it can be
> > archived, email a link to an audience, and save a snapshot in history.
> >
> > Can someone please help me with this? If not all then parts would be
> > appreciated!!!
> >
> > Anthony
> >

Scheduling Montly Report

Hi all,

I currently have a report which needs to be scheduled to run on every 1st of the month to get records of last month. For example, on Feb. 01 the report will get all records by the date range of Jan. 01 to Jan. 31. My current report does not have any defined report parameter. It gets all the date range it finds from the table.

Please advise how can I start with this.

Any help is much appreciated! Thanks!

Hi,

Couldnt get it completely.

you want to run a report on monthly basis, then you need to have two datetime parameters i.e. from_time and to_time, then you want default value to be last months dates, use expression for the defualt value....

your expr. for "from time" should be like

=switch(month(now())=1,"01/01/2007",

month(now())=2,"02/01/2007, and in same way you can have it for to time frame....

HTH

Priyank

|||

Hi

As i understand the requirement over here is to have a report which shows the data for previous month

say the report is executed on mar 1st then the report should display data till feb28th correct?

For this a report has to be created with 2 parameters Startdate and EndDate.

However subscription can be created in Report Manager.

Regards

Smitha

|||

You don't need a param for this, although to give you an perfectly appropriate example it would be good to know if you are calling a stored procedure or writing the query directly in the report, or what.

Let's say you are writing the query directly in the report, not a stored procedure.

You already know that you can schedule it to run on the first of the month, right? Here is a query that will do what you want, given that you know you are running it every month on the first:

Code Snippet

select <WHATEVER> from <YOUR TABLE> where

DATEDIFF(month,GETDATE()-1,<YOUR DATE COLUMN>) = 0

' the default behavior of the date subtraction is by days, see?

' and you're running the subscription on the first of the month,

' so this works.

Let's make it better. Here is a query that will do what you want, no matter what date of the month it is run on, which is : provide the results for the month *before* the month in which it is run:

Code Snippet

select <WHATEVER> from <YOUR TABLE> where

DATEDIFF(month,DATEADD(month,-1,GETDATE()),

<YOUR DATE COLUMN>) = 0

Now, if you prefer, you can add a parameter and give your parameter the default value of Today (you may have to do some CASTing in here, not checking this):

Code Snippet

select <WHATEVER> from <YOUR TABLE> where

DATEDIFF(month,DATEADD(month,-1,@.YourParam),

<YOUR DATE COLUMN>) = 0

... hope this helps,

>L<

|||

Thank you all for the helpful solutions.

Yes basically it is just to get a report of previous month when it is scheduled to run.

|||

Lisa that's a cool little function!

Only question I have it whether it would work if you had data for more than one year in the table? i.e If you had 2 rows, one with July 2006 and one with July 2007 wouldn't the DateDiff(month, etc) return 0 for that even though the year is different?

As my own $0.02 I usually use something like

Beginning of last month

DATEADD(month,DATEDIFF(month,0,getdate)-1,0)

Beginning of this month

DATEADD(month,DATEDIFF(month,0,getdate),0)

Beginning of next month

DATEADD(month,DATEDIFF(month,0,getdate)+1,0)

which is sort of based off similar logic. Found it on a forum, and loved it. Can also do days/weeks by just switching the period name.

|||

>> whether it would work if you had data for more than one year in the table

It will actually work fine, D, check it out:

select datediff(month, '1/1/2007','1/1/2004')

will return -36 even though both dates are (obviously) in January. 3 * 12.

It's a *difference of months*. Not a difference of *month numbers* <s>.

>L<

|||Right you are - I should have run it through Query Analyzer first

Scheduling Montly Report

Hi all,

I currently have a report which needs to be scheduled to run on every 1st of the month to get records of last month. For example, on Feb. 01 the report will get all records by the date range of Jan. 01 to Jan. 31. My current report does not have any defined report parameter. It gets all the date range it finds from the table.

Please advise how can I start with this.

Any help is much appreciated! Thanks!

Hi,

Couldnt get it completely.

you want to run a report on monthly basis, then you need to have two datetime parameters i.e. from_time and to_time, then you want default value to be last months dates, use expression for the defualt value....

your expr. for "from time" should be like

=switch(month(now())=1,"01/01/2007",

month(now())=2,"02/01/2007, and in same way you can have it for to time frame....

HTH

Priyank

|||

Hi

As i understand the requirement over here is to have a report which shows the data for previous month

say the report is executed on mar 1st then the report should display data till feb28th correct?

For this a report has to be created with 2 parameters Startdate and EndDate.

However subscription can be created in Report Manager.

Regards

Smitha

|||

You don't need a param for this, although to give you an perfectly appropriate example it would be good to know if you are calling a stored procedure or writing the query directly in the report, or what.

Let's say you are writing the query directly in the report, not a stored procedure.

You already know that you can schedule it to run on the first of the month, right? Here is a query that will do what you want, given that you know you are running it every month on the first:

Code Snippet

select <WHATEVER> from <YOUR TABLE> where

DATEDIFF(month,GETDATE()-1,<YOUR DATE COLUMN>) = 0

' the default behavior of the date subtraction is by days, see?

' and you're running the subscription on the first of the month,

' so this works.

Let's make it better. Here is a query that will do what you want, no matter what date of the month it is run on, which is : provide the results for the month *before* the month in which it is run:

Code Snippet

select <WHATEVER> from <YOUR TABLE> where

DATEDIFF(month,DATEADD(month,-1,GETDATE()),

<YOUR DATE COLUMN>) = 0

Now, if you prefer, you can add a parameter and give your parameter the default value of Today (you may have to do some CASTing in here, not checking this):

Code Snippet

select <WHATEVER> from <YOUR TABLE> where

DATEDIFF(month,DATEADD(month,-1,@.YourParam),

<YOUR DATE COLUMN>) = 0

... hope this helps,

>L<

|||

Thank you all for the helpful solutions.

Yes basically it is just to get a report of previous month when it is scheduled to run.

|||

Lisa that's a cool little function!

Only question I have it whether it would work if you had data for more than one year in the table? i.e If you had 2 rows, one with July 2006 and one with July 2007 wouldn't the DateDiff(month, etc) return 0 for that even though the year is different?

As my own $0.02 I usually use something like

Beginning of last month

DATEADD(month,DATEDIFF(month,0,getdate)-1,0)

Beginning of this month

DATEADD(month,DATEDIFF(month,0,getdate),0)

Beginning of next month

DATEADD(month,DATEDIFF(month,0,getdate)+1,0)

which is sort of based off similar logic. Found it on a forum, and loved it. Can also do days/weeks by just switching the period name.

|||

>> whether it would work if you had data for more than one year in the table

It will actually work fine, D, check it out:

select datediff(month, '1/1/2007','1/1/2004')

will return -36 even though both dates are (obviously) in January. 3 * 12.

It's a *difference of months*. Not a difference of *month numbers* <s>.

>L<

|||Right you are - I should have run it through Query Analyzer first

Scheduling Issue...need help please.

I have a report that has to be delivered via email on the last day of each
month. I am using a last_day function to capture the last day of each month.
Can I store this in a table and have RS2000 email based on the value in the
table? If so, how?
Thanks in advance
OSIs there any way you can upgrade to SQL 2005? The reporting services is SO
MUCH BETTER... and you can EASILY create a report subscription that will send
on the last day of the month.
--
~lb
"OriginalStealth" wrote:
> I have a report that has to be delivered via email on the last day of each
> month. I am using a last_day function to capture the last day of each month.
> Can I store this in a table and have RS2000 email based on the value in the
> table? If so, how?
> Thanks in advance
> OS

Scheduling Hourly Report between predefined hours

Hi everyone,

I'm using 2005 Reporting Services and trying to schedule an hourly report to be sent out between 8:00am and 8:pm. Am I doing something wrong or does SSRS really not support end time? Do I have to create 12 seperate jobs?

Any help would greatly be appreciated.

Thanks,

- gshaf

The RS scheduling does not support this. You can work around this, but it does have consequences. If you create a schedule you can then go into SQL Agent and modify the corresponding schedule to fire when you would like. The problem is that RS will reset the schedule every 12 hours. :) To stop RS from doing this, go into RSReportServer.config file and set IsSchedulingService to false. By doing this RS will not verify that the schedule data it has matches what SQL Agent has. If you view the schedule via Report Manager it will show the old schedule, not the modified SQL Agent schedule, and of course if you change it via Report Manager it will modify the SQL Agent job as well.

I hope that helps.

|||

Thanks very much... perhaps it's worth a shot.

- gshaf

scheduling delivery

i would like to ask how to execute the email delivery setting? can it be done
in the report server homepage'it is a must to get it work through web
service programming?
thanks in advanceIts form the report MANAGER home page http://servername/reports. Go to
whtever report you want the set the subscription on, and when you view the
report, you have a tab saying new subscription, click on tht and give the
parameter info and the schedule info.
"Jasonymk" wrote:
> i would like to ask how to execute the email delivery setting? can it be done
> in the report server homepage'it is a must to get it work through web
> service programming?
> thanks in advancesql

Scheduling bug?

Hi!

I'm trying to create a subsciption for my report. In first creation I can do scheduling just fine, but when I try to edit my schedule, it's totally different. It shows value 1.1.0001 and when I try to change it, it's gives me first message:

value of '1.1.0001 0:00:00' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'. Parameter name: Value (System.Windows.Forms)

and after that when pushing OK it gives me message: "The required field StartDateTime is missing from the input structure. (rsMissingElement)".

Do you think it's a bug or is there something which I'm doing wrong?

Tero Kruth

I guess you're talking about creating subscription using SQL Management Studio. If yes, then it's a known bug.|||I was talking about that. Thanks for the answer. Now I don't waste my time anymore.

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 a report to run every 30 minutes

Hi all,
I have a customer that wants a report to pull data, and report that data
every 30 minutes is that possible in SQL 2000 Reporting? They are trying to
upgrade to 2005 based on this request. How musch more functionslity in
reporting is there in 2005 as opposed to 2000 Reporting.
Of course they are behind the 8 ball and it just got dropped in my lap.
--
Zoomer Tech
A+,MCSE+ I/MCSAThere is some thing called subscription in both 2000 as well as 2005 you can
schedule a report and the parameters as well so that it runs and delivers to
a share or through email.
2005 has bit more enhancements like multi select, AS designer etc.. just
check in SQL SERVER 2005 site
Amarnath
"Zoomer Tech" wrote:
> Hi all,
> I have a customer that wants a report to pull data, and report that data
> every 30 minutes is that possible in SQL 2000 Reporting? They are trying to
> upgrade to 2005 based on this request. How musch more functionslity in
> reporting is there in 2005 as opposed to 2000 Reporting.
> Of course they are behind the 8 ball and it just got dropped in my lap.
> --
> Zoomer Tech
> A+,MCSE+ I/MCSA

Scheduling a Report based on an event

Is it possible to schedule a report based on a flag or stored procedure completing. Currently have an overnight load process which must complete before the report starts. Any suggestions would be most appreciated
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.If it's possible to detect that your stored proc is finished within SQL
(either because it sets a flag in a table or be the mire presence of data it
creates or something) there might be a way. Might not be the optimal
solution, but your SQL dataset could reference that flag so that no data is
returned at all to the report if the flag doesn't exist. You'd have to set
it up so that the data table the report references doesn't exist at all until
the stored proc is finished. Then schedule your report job to run multiple
times near the time when you expect the SQL proc to finish. Without the data
table existing, your Rpt Services job should just error out and product
nothing. Again, not an elegant solution, but if you're desperate might be
something to toy around with ... a place to start.
sebring1130
"SqlJunkies User" wrote:
> Is it possible to schedule a report based on a flag or stored procedure completing. Currently have an overnight load process which must complete before the report starts. Any suggestions would be most appreciated
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
>|||Sure this is real easy to do.
Create a schedule that has completed in the past - so effectively it will
never fire. Associate this schedule with a Report.
Now what happens is that a SQL Agent Job is created - that maps to the
schedule. You can run SQL Agent Jobs from the SQL Agent Management interface
by hand - or you can cause that job to run through T-SQL.
All that the SQL Agent Job does is create an entry in the Report Server's
Event table at the scheduled time. The Report Server Windows Service is
polling the Event table every 10 seconds or so - and if there are any events
to process it gets on and processes them.
So what you do is either include in your long running stored procedure a
call that will create the required entry in the Event table directly - or a
call that fires the SQL Agent Job.
- One word of warning though if you start editing the schedule in the Report
Manager, then the Report Manager can end up re-creating the SQL Agent Jobs -
and you lose reference to the actual Job.
However if you are disciplined enough then this approach works fine -
(Schedule in the past, have your own process force the SQL Agent Job to run)
Peter Blackburn
Hitchhiker's Guide to SQL Server 2000 Reporting Services
http://www.sqlreportingservices.net
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OWMxVAoxEHA.3080@.TK2MSFTNGP14.phx.gbl...
> Is it possible to schedule a report based on a flag or stored procedure
> completing. Currently have an overnight load process which must complete
> before the report starts. Any suggestions would be most appreciated
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
> supports Post Alerts, Ratings, and Searching.

Scheduling a Report

Hello,
I am trying to create a schedule to add snapshots of a certain report to
report history.
So in Report Manager, I go to History and create a schedule to to this. In
my understanding, i need to create a job to execute this shedule. So i go to
Enterprise Manager to create a job. But after this i am lost, basically. How
can i reference this schedule when i go to "New Job". Is there any code that
needs to be put in the "New Job" Wizard so that this schedule can be run?
Thanks
SanjeevYou do not go to Enterprise Manager to do this. Do it all from within Report
Manager.
First create your schedule using Site Settings, Manage shared schedules. Do
this if you want to re-use the schedule with other reports.
Next, navigate to the report's folder and bring up its Properties window.
With the Properties window displayed, there is a History link on the left
side of the screen. Check the option to "Use the following schedule to add
snapshots to report history", then specify the schedule underneath.
HTH
Charles Kangai, MCT, MCDBA
"Sanjeev" wrote:
> Hello,
> I am trying to create a schedule to add snapshots of a certain report to
> report history.
> So in Report Manager, I go to History and create a schedule to to this. In
> my understanding, i need to create a job to execute this shedule. So i go to
> Enterprise Manager to create a job. But after this i am lost, basically. How
> can i reference this schedule when i go to "New Job". Is there any code that
> needs to be put in the "New Job" Wizard so that this schedule can be run?
> Thanks
> Sanjeev
>
>|||Thanks Charles. That worked
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:3D77E5E5-BAE9-484B-A87C-714EAD5350FC@.microsoft.com...
> You do not go to Enterprise Manager to do this. Do it all from within
> Report
> Manager.
> First create your schedule using Site Settings, Manage shared schedules.
> Do
> this if you want to re-use the schedule with other reports.
> Next, navigate to the report's folder and bring up its Properties window.
> With the Properties window displayed, there is a History link on the left
> side of the screen. Check the option to "Use the following schedule to add
> snapshots to report history", then specify the schedule underneath.
> HTH
> Charles Kangai, MCT, MCDBA
> "Sanjeev" wrote:
>> Hello,
>> I am trying to create a schedule to add snapshots of a certain report to
>> report history.
>> So in Report Manager, I go to History and create a schedule to to this.
>> In
>> my understanding, i need to create a job to execute this shedule. So i go
>> to
>> Enterprise Manager to create a job. But after this i am lost, basically.
>> How
>> can i reference this schedule when i go to "New Job". Is there any code
>> that
>> needs to be put in the "New Job" Wizard so that this schedule can be run?
>> Thanks
>> Sanjeev
>>

Scheduled snapshots not showing up

I have set a report to render from a snapshot (Properties>Execution). I have
also set up a subscription that emails the report to me.
I am receiving the report via email based on the designated schedule (SQL
Agent is running). However, when I look at the report history, I only see one
snapshot, which is one that I manually created.
Can anyone explain this to me? I would expect to see a snapshot for every
emailed report that I have received.There's an option to show the execution snapshots in your history section.
Tick that and they should show up from that pointonwards.
I've found the SnapshotUpdated trigger to be a bit flaky so I run to
seperate schedules, one to snaphot and then one to deliver the reports.
Hope this helps,
DF
"DBA72" wrote:
> I have set a report to render from a snapshot (Properties>Execution). I have
> also set up a subscription that emails the report to me.
> I am receiving the report via email based on the designated schedule (SQL
> Agent is running). However, when I look at the report history, I only see one
> snapshot, which is one that I manually created.
> Can anyone explain this to me? I would expect to see a snapshot for every
> emailed report that I have received.

scheduled snapshot

I have a report that uses execution snapshots but for some reason the
snapshots don't seem to be executing.
I used 'Render this report from an execution snapshot'
'Use the following schedule to create exection snapshot'
and configured it to create a snapshot everyhour.
but I don't receive a notification every hour. (As a test I wanted it to
notify me of updated snapshots).
The only time it seems to work is when I check 'Create a snapshot of the
report when the apply button is selected'
Is there anything I shoud check to make sure scheduled snapshots work?
JacksonI've been doing some more testing and it seems like it doesn't do scheduling
for odbc connections to access databases. The snapshot schedule works fine
with SQL but doesn't seem to do anything for access databases.
Is there anyway possible to schedule snapshots for an access database?
TIA,
Jackson
"Jackson" <jackson_num5@.yahoo.com> wrote in message
news:essnC6SvFHA.2504@.tk2msftngp13.phx.gbl...
>I have a report that uses execution snapshots but for some reason the
>snapshots don't seem to be executing.
> I used 'Render this report from an execution snapshot'
> 'Use the following schedule to create exection snapshot'
> and configured it to create a snapshot everyhour.
> but I don't receive a notification every hour. (As a test I wanted it to
> notify me of updated snapshots).
> The only time it seems to work is when I check 'Create a snapshot of the
> report when the apply button is selected'
> Is there anything I shoud check to make sure scheduled snapshots work?
> Jackson
>

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