Using a File Date and Time as Custom Time Trigger - VisualCron - Forum

Community forum

klewis10367
2011-06-07T14:35:58Z
Is there a way to create a custom time trigger based on a modified date time of a file? Basically, i want to take the modified date and time, use it as a variable and then create a time trigger. The reason why is that i am downloading records from a website where limited to 5000 a day. The time trigger is not always 24 hours as the last record to download date time is what dictates the 24 hours. As An example the Date Modified of my last download was 06/06/2011 8:46am, but i started the job at 7:40 on the same day...if i was to have my job run at 7:40 today it would fail...the time trigger would need to be 06/07/2011 at 8:47am
Support
2011-06-07T14:38:09Z
Currently not, unless you use the API - but it would require some programming to read this information and to create a Trigger from that.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2011-06-07T14:40:02Z
Seems like you should use some kind of event trigger instead of based on time.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2011-06-07T14:40:21Z
Thanks for the quick reply. Is this something that would be a candidate for a enhancement suggestion?
Support
2011-06-07T14:41:35Z
klewis10367 wrote:

Thanks for the quick reply. Is this something that would be a candidate for a enhancement suggestion?



I am not seeing the full picture of what you really want to do right now and why you can base the Trigger on an event instead of time?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2011-06-07T14:41:52Z
I thought of that, but the only thing i saw was a file trigger, but i don't think i could add time to the last modified date when using a file trigger?
klewis10367
2011-06-07T14:43:53Z
There is no event that i can think of with this particular job. It is just me running an SSIS package to download info from a website.
Support
2011-06-07T14:48:59Z
The request seems very specific and I am not sure where we should add this functionality. Not in the actual Trigger - it is just a Trigger. Perhaps in Conditions to compare a Variable against a File time. If larger/less than you could just let the Condition wait. That is one idea.

Another idea is to open up for a Task or Condition where you can run and compile any code at runtime. Then base the result on what you want to do. This would require some programming skills but perhaps the community can help to bring up snippets for stuff like this. This would solve very specific requests and ability to do everything that VisualCron can't do at the moment.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2011-06-07T15:12:26Z
Great Idea about the variable and waiting option. I will let you know how it goes.
Scroll to Top