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


  1. Forum
  2. Support
  3. General problem solving
  4. SQL Server Execute Procedure, If Returns Records, Proceed to Next Step
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.
 Reply
 View All Posts by User
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!
 Reply
 View All Posts by User
Similar Topics
Users browsing this topic
  1. Forum
  2. Support
  3. General problem solving
  4. SQL Server Execute Procedure, If Returns Records, Proceed to Next Step
 

© SMA Technologies. All Rights Reserved, 2024 Version: 11.1.26.176dac7

Privacy Policy
Terms & Conditions
Sitemap
Scroll to Top