AnsweredAssumed Answered

Subscription reporting and Nintex

Question asked by cazza162 Expert on Aug 10, 2017
Latest reply on May 21, 2018 by mindymac03

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

Outcomes