Skip to main content

We have an SSRS report that has a Data Driven Subscription set up to create a pdf of the report and email the report to specified users.  Manually this all works fine.

What I need to be able to do is get this driven by Nintex.

The data driven subscription creates a job in SQL Server Agent > Jobs

I wanted to use "Execute SQL" in Nintex to call the job:

However it would appear I cannot pass the parameter into the SQL job?  Has anyone done anything similar?

We do not have convert to pdf forms enterprise or DocGen so really looking for a way to muddle through with this requirement...

Oh man. I am needing to execute a SQL job and pass parameters and am not coming up with much. Did you ever find a way to do this?


Reply