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

Reporting Services Sheduled job Failing Expand / Collapse
Author
Message
Posted Saturday, June 6, 2009 4:53 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:57 PM
Points: 51, Visits: 232
On SqL Server 2005 Std Edition Along with reporting services with sp2 we have more that 50 reports and these 50 reports are sheduled to run automatically, but it is not running as per sheduled however when we are trying to run the job it is running sucessfully.

Issue is we want this job to be run automatically without any human interface.

Please suggest us on the same
Post #730197
Posted Saturday, June 6, 2009 8:29 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 9:10 AM
Points: 3,433, Visits: 14,429
The things to check are Agent permissions, SMTP or Exchange configuration if you are not using IIS SMTP, you have to check to make sure everything was setup as expected.



Kind regards,
Gift Peddie
Post #730243
Posted Saturday, June 6, 2009 8:44 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:57 PM
Points: 51, Visits: 232
hi
Exact issue is that out of 250 reports only 50 reports are running sucessfully. manually we can run the reports and what is the permission we can check on Agent for the same.

Bala
Post #730249
Posted Saturday, June 6, 2009 8:55 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 9:10 AM
Points: 3,433, Visits: 14,429
If 50 are running then it may be capacity related if you are using IIS SMTP then you may have to use Exchange because IIS SMTP load may not be up to 250 so you could try running 50 at a time so try five subscriptions.

Kind regards,
Gift Peddie
Post #730253
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse