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

Subscriptions from Reporting Services get unintelligable job names in SQL Server Agent Expand / Collapse
Author
Message
Posted Thursday, May 22, 2008 4:36 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 12:33 PM
Points: 52, Visits: 201
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.



Post #505540
Posted Thursday, July 3, 2008 4:52 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 11, 2014 4:07 PM
Points: 207, Visits: 330
Nice work Steve,
Cheers.


"Ask me your questions, bridgekeeper. I'm not afraid"
Post #528433
Posted Thursday, October 23, 2008 8:44 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, August 15, 2014 12:18 PM
Points: 79, Visits: 740
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?
Post #590505
Posted Friday, September 25, 2009 12:20 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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.
Post #793668
Posted Tuesday, July 20, 2010 6:29 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 10:43 AM
Points: 70, Visits: 611
Thanks Steve, It worked for me too..... I hope next releases, SSRS gives us the option to rename it or use the GUID.
Post #955482
Posted Wednesday, February 9, 2011 9:48 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 7:28 PM
Points: 41, Visits: 46
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.
Post #1061683
Posted Monday, June 11, 2012 3:58 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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.
Post #1314154
Posted Friday, February 15, 2013 1:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, January 24, 2014 7:44 AM
Points: 190, Visits: 319
Thanks! I used this view and it helps :)
Post #1420425
Posted Friday, February 22, 2013 7:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 2:17 PM
Points: 53, Visits: 161
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
Post #1423055
Posted Wednesday, July 10, 2013 10:55 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, August 6, 2014 8:12 AM
Points: 1,815, Visits: 3,456
Hey Donna, glad to know it still works and is helping folks out!

Steve



Steve.
Post #1472427
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse