Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

HOWTO: Create an Asynchronous Schedule For a Report Server Report Expand / Collapse
Author
Message
Posted Tuesday, January 18, 2005 1:10 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:39 PM
Points: 388, Visits: 1,034
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/ALeonard/howtocreateanasynchronousscheduleforareportserverr.asp

Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #156209
Posted Monday, September 17, 2007 2:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 11, 2008 8:19 AM
Points: 1, Visits: 4
This is great article.

But when i tried to follow the step as said, the job never got created in my "Reporting Services SQL Server Jobs".

Can you please let me know what rights need to be given and to which process ??

Thank you in Advance.
Post #399795
Posted Monday, August 04, 2008 10:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 02, 2010 1:21 PM
Points: 8, Visits: 157
I was using this approach, but instead of renaming the job I created a new one and borrowed the step from the original job. I did this because I wanted to control multiple report refreshes from a single job. I deleted the "guid" named job. However, I noticed that the next day the "guid" named job was back.

(1) It would have been nice if Microsoft would give us the ability to name the job during the "configuration" creation.
(2) If the report execution configuration is turned off, the event behind the original job and now copied into the new one goes away. Micosoft could have done a better job here.

Post #546205
Posted Friday, August 08, 2008 7:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 02, 2010 1:21 PM
Points: 8, Visits: 157
I now tried basically the same approach as the article. After renaming the “guid” named job to some meaningful name, I also disabled it and had the newly renamed job called by another. The idea was to have a “main” job call all the report refresh jobs as a single unit.

The problem is, the next morning I came in and all the “guid” jobs that were renamed are now back and enabled. Apparently, reporting services recreated them based on the schedule that was setup.

Is there some place within the reporting service database where the job names are referenced that could be adjusted to call the ‘renamed” version?
Post #549120
Posted Friday, August 08, 2008 2:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 02, 2010 1:21 PM
Points: 8, Visits: 157
Ok, got it working I think. The key is not to remove the schedule within the job but to simply disable the job.
Post #549588
Posted Monday, August 11, 2008 7:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 02, 2010 1:21 PM
Points: 8, Visits: 157
Nope: The "guid" named jobs reappeared. It is like there is a nightly reporting servcie job that goes though and checks to see if the job exists and rebuilds it. I will try to just disable the job and see if that does the trick. regradless, it looks like I stuck with the "guid" names. I do have a query that helps identify the job to report:

select jobs.[name] as JobName,c.[name] as ReportName
from ReportServer$SQL2005.dbo.[catalog] as c
inner join ReportServer$SQL2005.dbo.[ReportSchedule] as rs
on c.ItemID = rs.ReportID
inner join msdb.dbo.sysjobs_view as jobs
on jobs.[name] = convert(varchar(100),rs.scheduleid)
order by jobs.[name]
Post #550227
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse