Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


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.
Sponsor
Forum information
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