Community forum

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

Notification

Icon
Error

Options
View
Go to last post Go to first unread
Offline Jason Love  
#1 Posted : Tuesday, September 6, 2016 9:24:48 PM(UTC)
Jason Love

Rank: Paid support

Joined: 5/2/2016(UTC)
Posts: 6
United States
Location: Houston, TX

Thanks: 2 times
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.
Offline Support  
#2 Posted : Tuesday, September 6, 2016 11:18:05 PM(UTC)
Support

Rank: Official support

Joined: 2/23/2008(UTC)
Posts: 11,222

Thanks: 875 times
Was thanked: 446 time(s) in 424 post(s)
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!
thanks 1 user thanked Support for this useful post.
Jason Love on 9/7/2016(UTC)
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Scroll to Top