|
|
|
Valued Member
      
Group: General Forum Members
Last Login: 2 days ago @ 12:25 PM
Points: 52,
Visits: 185
|
|
Prakash.Bhojegowda (2/13/2008) Thanks Jason,
Would you mind taking a look at another question that I have?
I have a Network Load Balanced Web Farm ( 2 Nodes configured as Active - Active) with SQL Reporting services installed. Report Server database is on the SQL server. When I subscribe a report on the cluster, it appears on bothe nodes. My question is: Will the report be kicked off on both the nodes of the web farm?
Any help would be appreciated.
Thanks
Prakash BhojeGowda
No, it will not, the report is a SQL Job, not a web server job. The subscriptions are independent of the number of front end servers you have in the RS Farm.
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Tuesday, July 03, 2012 12:05 AM
Points: 207,
Visits: 294
|
|
Nice work Steve, Cheers.
"Ask me your questions, bridgekeeper. I'm not afraid"
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Today @ 12:25 PM
Points: 79,
Visits: 704
|
|
| Aren't there other processes for RS that generate a job named with a GUID? Is there anyway to catch all these jobs in a view rather than just the subscription based ones?
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Wednesday, October 21, 2009 8:46 PM
Points: 1,
Visits: 24
|
|
| Thank you very much.. It's so helpful for me.
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Friday, June 14, 2013 12:57 PM
Points: 68,
Visits: 564
|
|
| Thanks Steve, It worked for me too..... I hope next releases, SSRS gives us the option to rename it or use the GUID.
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Wednesday, July 11, 2012 12:28 AM
Points: 38,
Visits: 37
|
|
This is still an issue in SSRS 2008 and 2008 R2. We hit this today and, in the interests of not breaking Reporting Services whilst still preserving the sanity of our sa users, decided to just hide them from view altogether. I achieved this by altering the where clause on msdb.dbo.sysjobs_view:
WHERE ((owner_sid = SUSER_SID()) OR (ISNULL(IS_SRVROLEMEMBER(N'sysadmin'), 0) = 1) OR (ISNULL(IS_MEMBER(N'SQLAgentReaderRole'), 0) = 1) OR ( (ISNULL(IS_MEMBER(N'TargetServersRole'), 0) = 1) AND (EXISTS(SELECT * FROM msdb.dbo.sysjobservers js WHERE js.server_id <> 0 AND js.job_id = jobs.job_id))) -- filter out local jobs ) AND ( ORIGINAL_LOGIN() != 'sa' OR jobs.name not like '________-____-____-____-____________' ) (That's 8, 4, 4, 4, 12 underscores in the match by the way.)
Reporting Services can still see and manage the jobs, but our sa user can't see them and/or break them.
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Monday, September 10, 2012 12:00 PM
Points: 35,
Visits: 34
|
|
Hi,
Currently, I am working on scheduling subscriptions from my ASP.Net application. I want to know what aal tables are affected when we update the date and time for any subscription. I want to perform this task from my application. Right now, I have only startdate from schedule table to update but this is not firing the scheduling part for the job.
Any help will be appreciated.
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, April 23, 2013 11:06 AM
Points: 190,
Visits: 301
|
|
| Thanks! I used this view and it helps :)
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 5:03 AM
Points: 50,
Visits: 142
|
|
Hi, Steve - This post was tremendously helpful to me, so I wanted to share my thanks for the great script. I poked around, looking for the subscription emails enough to know that it was going to take quite a while to follow that trail. Saved me a lot of time trying to track the subscription emails down. And time is in short supply, as always!
Thanks again --
Donna
|
|
|
|