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

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

Welcome Guest! To enable all features please Login or Register.

Jason Love
Paid support Topic Starter

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

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Support
Official 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!