Hmmm I tried that, but maybe I tried a comma. Once the subscription is built in reporting services, are the parms stored or do I have to declare them each time? Can you give me a sample set for your paramters? Which ones are required?
exec data_driven_subscription
@scheduleName = 'sales_call_sheet',
@emailTO = 'parag.shah@leeirnk.com',
@emailCC = '',
@emailBCC = '',
@emailReplyTO = '',
@emailBODY = '',
@parameterName = '',
@parameterValue = '',
@sub = '',
@renderFormat = 'PDF',
@exitCode = '',
@exitMessage =''