SQL Server Execute Procedure, If Returns Records, Proceed to Next Step - VisualCron - Forum

Community forum

Jason Love
2016-09-06T19:24:48Z
SQL Server Execute Procedure, If Returns Records, Proceed to Next Step
I want to run a stored procedure, every X minutes. Step 1
If it returns rows, then I would like to proceed to step 2, but only if it returns records.
Can you assist?
Thank you.
Support
2016-09-06T21:18:05Z
You have the value {TASK(Active|Result.NoRows)} which returns number of rows picked up. You can compare against this value in the Flow tab of the SQL Task and decide what do do depending on result.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top