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...