September 3, 2010 at 11:46 am
We have a bunch of subscription distributions with distribution times which happened to be during a couple of hours when the server was having problems.
Server's back, but the status of the subscriptions have "Mail Sent" dates of yesterday.
No indication of trying and failing today, no notifications received, but no indication of success.
I have to assume the things didn't fire at all and so I have to send them all manually, requiring (as far as I know) rescheduling the times for each and then putting them all back after they fire).
Anyone know of a "quick trigger" way to send a scheduled subscriptions?
I did find that this can be accomplished in SSRS 2008 - and our 2008 box is being prepped...but the current problems apply to 2005...
...another question I should have thought of "in prospect"
Thanks~
September 3, 2010 at 1:41 pm
SSRS subscriptions are agent jobs in SSMS. You can fire them off manually like any scheduled job. Just right click the job and start.
The hard part is determining which reports you want to fire, because the jobs are usually labeled with some kind of GUID instead of the report name.
You can look in the Report Server database in the Catalog table to see the GUID translation to the report name.
At least this way you don't have to redefine the job schedule one time, and then redefine it back, but I am not sure this is better or just different.
September 3, 2010 at 1:57 pm
Actually, I appreciate that thought. I found a technique using rs.exe with an .rss file that should have done it - but I got permissions errors trying to run it - as an admin!
But as part of all that, I did decipher the IDs, but was resigned to doing it the hard way - probably would have overlooked completely using the agent per your suggestion.
I determined that it is the RptScheduleID that corresponds to the cryptic job list. Tested the Start Job with one and it worked great, so away I go to do the multitudes.
Sincerest thanks!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply