Manually run Subscription

I have gathered it is pretty tough to manually run a subscription. I have a
shared schedule with about 50 jobs attached. I need to rerun about half of
them. What is the best way to rerun specific reports in a shared schedule?
I am running SRS 2005 Standard.
Also, are there any fixs to this in a future releases?
Thanks.I'm not sure about shared schedules...
But this is what I do if I need to manually run a subscription. Get the
SubscriptionID and insert it in the WHERE Clause
SELECT 'EXEC msdb..sp_start_job @.job_name=''' + CONVERT(varchar(100),
scheduleid) + ''''
FROM ReportSchedule WITH(NOLOCK)
INNER JOIN Subscriptions WITH(NOLOCK) ON
Subscriptions.SubscriptionId = ReportSchedule.SubscriptionId
WHERE Subscriptions.Subscriptionid = [INSERT YOUR ID HERE]
Then run that resulting EXEC statement that gets outputted. It will start
the SQL Agent job that is associated for that subscription.
"Brian Shannon" wrote:
> I have gathered it is pretty tough to manually run a subscription. I have a
> shared schedule with about 50 jobs attached. I need to rerun about half of
> them. What is the best way to rerun specific reports in a shared schedule?
> I am running SRS 2005 Standard.
> Also, are there any fixs to this in a future releases?
> Thanks.
>
>