IF Condition for TDP 3.5

Toad Data Point
1

Hello,

I am trying to create an IF condition inside an automation that pauses for 30 seconds on weekdays and 2 hrs on weekends. Can someone help me with this?

2

You can do this a number of ways but the most generic I know of is:

  1. Add Execute Script using the TOAD Sample Access Database

Update the SQL to: select weekday(date())

1 = Sunday & 7 = Saturday

  1. Within the If condition

#Execute_1_SQL# >1 and #Execute_1_SQL# < 7 ~ WEEKDAY

#Execute_1_SQL#= 1 or #Execute_1_SQL# = 7 ~ WEEKEND

weekday.jpeg
weekday.jpeg814×281 29.2 KB

3

Dave, this worked on the first try!

thanks so much for the help, this will cut out some time working on the weekend