cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
mindymac03
Nintex Newbie

Call SQL Job and pass parameters via Nintex workflow

Hello - I have a workflow with an Execute SQL statement. I want to use it to call a SQL job that calls a stored procedure with parameters. I can't figure out if it's possible, let alone the syntax.

Side notes: My Execute SQL statement has a working connection string. I have verified that by calling a stored procedure that needs no parameters and also by putting an INSERT statement into the Query field of the Execute SQL workflow step. So the connection string and user ID/password are fine. I have verified with our DBA that I am using a user ID that has rights to insert into the table in question.

With all that as background - what I am really needing to do is call a SQL job that executes a stored procedure with parameters. I can see in various forums (like this one -- sql server - How to pass a parameter to a SQL Job that will execute a stored procedure - Stack Overf... ) that calling a SQL job w/ parameters is doable, but I need to do it from a Nintex workflow/Execute SQL step. Has anyone done this? 

This -   - was the closest I could find. Not a good sign. Any clues are appreciated.

Tags (3)
0 Kudos
Reply
3 Replies
mindymac03
Nintex Newbie

Re: Call SQL Job and pass parameters via Nintex workflow

I ended up going a different route for this puzzle.

0 Kudos
Reply
Automation Master
Automation Master

Re: Call SQL Job and pass parameters via Nintex workflow

Can I ask what the different route was?

0 Kudos
Reply
mindymac03
Nintex Newbie

Re: Call SQL Job and pass parameters via Nintex workflow

Hi. Sure. Instead of using SSRS to build reports, I am creating an html file in SharePoint and storing it in a document directory on the SharePoint site. This way, I don't need to pass parameters outside of SP because I have all the info needed from within the workflow where I'm creating the html file. It is my makeshift version of a SharePoint report.

Reply