I am looping the job with records because.

I created a subscription to email a report in reporting services. and i observed that a subscription creates a job and parameter fields in the subscriptions table.

I want to send a report to different clients having different parameter values, email address. Top do this for every record i am overwriting the parameter values in subscription table and then executing the job.

so that i can generate the reports with different parameters.

And we are using the standard edition of sql server.

Please help if you know any other way to do this task.

Any help is appreciated

Narayana