Starting with task #2 of a job when it is a specific time - VisualCron - Forum

Community forum

SqlDev2021
2021-04-30T16:14:23Z
Hello, I have a job with multiple tasks. I would like to configure it so that when the job is executed it runs all tasks unless it is a specific time rounded to the hour.

For example, when the job is run at 1 PM I would like it to run all tasks, but if it is run at 7 PM I would like it to start at task #2 and SKIP the first task. I tried doing this via a condition but have been unsuccessful. Here is my setup. Based on the documentation this configuration should skip the first task if TRUE (and yes, I changed value 2 to the current time to test) but it doesn't seem to affect anything. I also validated that the value 1 matches value 2

Thanks

image.png

image.png
thomas
2021-05-02T19:45:18Z
{DATEFORMAT(htt)} return lower case: String equality is case sensitive by default.
image.png

I would use {DATEFORMAT(HH)} instead and check for the value 19

As an alternative to using a condition, you can use the Flow tab, see image

image.png
Support
2021-05-04T12:59:13Z
Originally Posted by: SqlDev2021 

Hello, I have a job with multiple tasks. I would like to configure it so that when the job is executed it runs all tasks unless it is a specific time rounded to the hour.

For example, when the job is run at 1 PM I would like it to run all tasks, but if it is run at 7 PM I would like it to start at task #2 and SKIP the first task. I tried doing this via a condition but have been unsuccessful. Here is my setup. Based on the documentation this configuration should skip the first task if TRUE (and yes, I changed value 2 to the current time to test) but it doesn't seem to affect anything. I also validated that the value 1 matches value 2

Thanks

image.png

image.png



Thomas gave you some great advice. Let me know if you still are having issues - alternatively mail us at support@visualcron.com
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
SqlDev2021
2021-05-04T18:41:25Z
Thanks, this is exactly what I needed. It worked
Support
2021-05-05T12:08:20Z
Originally Posted by: SqlDev2021 

Thanks, this is exactly what I needed. It worked



Great! Thanks for updating us
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Scroll to Top