Executing SP from Workflow with delay

Question

Hi Folks,

I want to call an SP from alterx. So far so good, I just use the pre-sql statement , open the WF and off it goes.

However, I've got a ton of SPs I need to create some links for as still in the dev process.

Is there a way to have the SP run not when you simply open the WF, but when you execute it?

Thanks

Steve

danilang · Answer

Hi @stevehughes

Pre-SQL statements run when the workflow is opened or any configuration change is made to the workflow.  For this reason it's best to use them only when required and use the "Table or Query" as much as possible.  You can disable this by going to Alteryx Designer > Options > User Settings > Edit User Settings and checking "Disable Auto Configure" in the "Advanced".  If you check that off it will prevent your Pre-SQL from running. However, it also prevents metadata from passing automatically through the workflow, so some tools will get harder to use (for example the Summarize Tool).  To manually update the metadata in the workflow, press F5

Dan