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

Community forum

  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
 

© VisualCron

Scroll to Top