Thanks for the reply Daniel.:-)

I want create a subscription from the stored procedure.

Assuming the Stored procedure will have the inputs for schedules and export format etc.

When I run procedure i want the report to subscribe as we create a new subscription from report manager.