Skip to main content
Nintex Community Menu Bar
Solved

SQL request output

  • September 29, 2021
  • 1 reply
  • 22 views

Forum|alt.badge.img+2

Hello, 

Is there a way I can use Execute SQL request in a workflow on a hourly basis, retrieve data from a SQL data base  and update a Choice column with the output from SQL. 

 

@R

 

Best answer by sumitdeJedi

Hiya,

 

You could configure your workflow as a site workflow, and then setup a scheduled  for it, to run run every hour:

 

https://help.nintex.com/en-us/nintex2013/help/workflow/RootCategory/SharePoint/Nintex.Workflow.SchedulingWorkflow.htm

 

I hope that helps,

 

Sumit

1 reply

sumitdeJedi
Nintex Employee
Forum|alt.badge.img+9
  • Nintex Employee
  • Answer
  • October 18, 2021

Hiya,

 

You could configure your workflow as a site workflow, and then setup a scheduled  for it, to run run every hour:

 

https://help.nintex.com/en-us/nintex2013/help/workflow/RootCategory/SharePoint/Nintex.Workflow.SchedulingWorkflow.htm

 

I hope that helps,

 

Sumit