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

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

schedules web page problem

hi all,

first of all i'm sorry for my bad english, i hope someone understand me.

i have a problem with schedules in reporting services.
i create a new one and i had no problem doing it.
the creation of the schedules make a new job in the sql server.
the job in the sql server works right.
instead the schedule's informartion in the reporting services web page doesn't refresh.
the schedule web page always reports the column "last execution" = never and the "next execution" = the first value.
any subscriptions set on the schedule doesn't work.

above some information about the installation:

- sql\report server is in another intranet. I manage the site from a different intranet.
- i restore on the main server the ReportServer and the ReportServerTempDB from the deployment server. i read the microsoft msdn to restore the db.

hope someone could help me
thanks
nicola

The microsoft article to restore reportserver db is very incomplete.. I do the following:
in ReportServer - Database

EXEC dbo.sp_AlterOwnerOfAgentJob @.username='ASPNET'
GO
EXEC dbo.sp_AlterOwnerOfSubscriptions 'ITEMOwner'
GO

where ASPNET is the assount of iis / application pool and ITEMOwner is a user from your domain. (usually this name has to be fullqualified domain\username)

The stored procedures are:
USE [ReportServer]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[sp_AlterOwnerOfSubscriptions] ( @.username nvarchar(128))
AS
BEGIN
/* ?ndert den Besitzer der Abonnements, da sonst die Fehlermeldung:
"Benutzer XY wurde nicht gefunden"
Beim nachtr?glichen ?ndern eines Abos auftreten kann
*/

SET NOCOUNT ON;
declare @.UserID uniqueidentifier
/* ID aus Benutzertabelle holen */
select top 1 @.UserID=userid from users where username=@.username
if @.UserID is null
begin
print '======================================================='
print 'ERROR: The given user was not found'
print 'Check if''' + @.username + ''' is correct!'
print '======================================================='
end
else
begin
print 'Changing subscription user to: ' + @.username
update dbo.Subscriptions set OwnerID=@.UserID,ModifiedByID=@.UserID,ModifiedDate=getDate();
update dbo.Schedule set CreatedById=@.UserID;
end
END

GO

/* =========================================================================== */

CREATE PROCEDURE [dbo].[sp_AlterOwnerOfAgentJob] ( @.username nvarchar(128))
AS
BEGIN
/*
Diese SP ?ndert den Besitzer der SQL-Server Agent-Jobs, diese werden
f?lschlicherweise auf SYSTEM gesetzt, sollten aber ASPNET sein!
*/
SET NOCOUNT ON;
declare @.jobname nvarchar(128),@.servername nvarchar(128),@.UserID uniqueidentifier
/* Cursor zum auslesen der aktuellen Jobs */
DECLARE job_cursor CURSOR FOR select name from msdb.dbo.sysjobs
OPEN job_cursor

/* Resultset durchgehen und Besitzer jedes Jobs setzen */
FETCH NEXT FROM job_cursor INTO @.jobname
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'Changing owner to: ''' + @.username + ''' for job ' + @.jobname
EXEC msdb.dbo.sp_update_job @.job_name=@.jobname,
@.owner_login_name=@.username
FETCH NEXT FROM job_cursor INTO @.jobname
END
/* Resultset / Cursor wieder schlie?en und Freigeben */
CLOSE job_cursor
DEALLOCATE job_cursor
END

GO

/* =========================================================================== */

Usually it works after that.. If not rebooting is a good choice ;) I was trying for 2hours to get the subscriptions work, after rebooting all went fine ;)

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

schedule into excel directly

Is it possible to schedule into excel directly, without choosing excel and
exporting once the report has been delployed onto the web in reporting
services.
--
shelYou can access the Excel-file via URL.
There may be other possibilities.
Ex:
http://server/ReportServer?%2fReportSolution%2fOperationalReport&datebegin=01.01.2004+00%3a00%3a00&dateend=01.01.2005+00%3a00%3a00&systemid=1&rs%3aCommand=Render&rs%3AFormat=EXCEL
You can find out the URL by copying it when u export the report as excel file.
Ya
"shel" wrote:
> Is it possible to schedule into excel directly, without choosing excel and
> exporting once the report has been delployed onto the web in reporting
> services.
> --
> shel|||--
shel
"Y. Adams" wrote:
> You can access the Excel-file via URL.
> There may be other possibilities.
> Ex:
> http://server/ReportServer?%2fReportSolution%2fOperationalReport&datebegin=01.01.2004+00%3a00%3a00&dateend=01.01.2005+00%3a00%3a00&systemid=1&rs%3aCommand=Render&rs%3AFormat=EXCEL
> You can find out the URL by copying it when u export the report as excel file.
> Ya
>
> "shel" wrote:
> > Is it possible to schedule into excel directly, without choosing excel and
> > exporting once the report has been delployed onto the web in reporting
> > services.
> > --
> > shel
Thanks for this - I have also worked out how to use the subscriptions.

schedule export of report

What is the syntax (or process) to schedule a reporting services report to be
exported as and Excel spreadsheet and then emailed to recepients?
Are there any examples that I could refer to?
I would like to write some kind of script and schedule this for every day.its the UNC mapping, you dont use the drive letter. Example:
\\server\folder1\folder2\folder3\application
"john d" <johnd@.discussions.microsoft.com> wrote in message
news:9E9BAAB5-CD24-4CCC-A892-A424BBCA498F@.microsoft.com...
> What is the syntax (or process) to schedule a reporting services report to
> be
> exported as and Excel spreadsheet and then emailed to recepients?
> Are there any examples that I could refer to?
> I would like to write some kind of script and schedule this for every day.|||nevermind, I misread your post
"john d" <johnd@.discussions.microsoft.com> wrote in message
news:9E9BAAB5-CD24-4CCC-A892-A424BBCA498F@.microsoft.com...
> What is the syntax (or process) to schedule a reporting services report to
> be
> exported as and Excel spreadsheet and then emailed to recepients?
> Are there any examples that I could refer to?
> I would like to write some kind of script and schedule this for every day.

Schedule and Delivery Processor errors

Hi all,

We're running into some random errors on our reporting server (Windows Server 2003, SQL Server 2000 Enterprise). In the application logs, we're seeing several Schedule and Delivery Processor errors (ID 108)...one for each processing extension (FileShare, Excel, HTML, etc.). In the security logs, at the same time of day, are several failure audits with the following info:

EventID: 680
User: NT AUTHORITY\SYSTEM
Description: Logon attempt by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0. Logon account: sqluser.

The odd thing is that the schedules that are failing run perfectly about 98% of the time. Once every few weeks we have a situation like this and all of our reports (approximately 200 of them...mostly Excel, all of them sent via E-Mail) fail.

Any ideas as to what might be causing this, and why it would only happen occasionally? Any help would be appreciated! Thanks!

-Brian
http://searchwindowssecurity.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid45_gci1007131_tax299886,00.html?bucket=ETA&topic=299886|||Thanks Greg, however this link seems to relate to making sure the ASP.NET account has the appropriate permissions on both the web server and the database. In my situation, the account (sqluser) has the correct permissions for the database. The database and report server/IIS are both on the same box if that matters.

In fact, and this is what is really confusing me, everything works just fine for weeks on end...then without warning I start getting these errors and the jobs fail. Same account, same reports, same schedules, same recipients...nothing has changed, yet something has caused these errors. Any other thoughts?
|||

Do you think it could be a DOS attack?

Is it happening the same day of the week? Same time of day?

How many "accounts" are accessing the server? Some versions of SQL have a max amount of connections before it denies access.