Scheduling Info.

Hi

I am using RS 2000. Currently I am scheduling the job by manually giving the date, time. Is there any possibility to make it as data driven so that I can configure each user with different timings.

Regards,

Venkataraman M

You can create multiple data driven subscriptions to run at different schedules for different users or user groups. You can filter users for which the subscription is run in data driven subscription query.

schedule data driven subscription using stored procedure

I'm trying to set up a data driven subscription using stored
procedure, on step 3 box I typed in my stored procudure
name:proc_Reports_test and clicked on validate button, I got following
error message:
The dataset cannot be generated. An error occurred while connecting to
a data source, or the query is not valid for the data source.
(rsCannotPrepareQuery)
Line 1: Incorrect syntax near 'proc_Reports_test'.
Has anyone else had this issue?
Thanks advance for any help.Try 'exec proc_Reports_test' instead
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Danni Liao" <danniliao@.yahoo.com> wrote in message
news:9d716b4a.0410210752.5a1fd0ba@.posting.google.com...
> I'm trying to set up a data driven subscription using stored
> procedure, on step 3 box I typed in my stored procudure
> name:proc_Reports_test and clicked on validate button, I got following
> error message:
> The dataset cannot be generated. An error occurred while connecting to
> a data source, or the query is not valid for the data source.
> (rsCannotPrepareQuery)
> Line 1: Incorrect syntax near 'proc_Reports_test'.
> Has anyone else had this issue?
> Thanks advance for any help.