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