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

Currently not, unless you use the API - but it would require some programming to read this information and to create a Trigger from that.

---

Seems like you should use some kind of event trigger instead of based on time.

---

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

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?

---

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?

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.

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.

---

Great Idea about the variable and waiting option. I will let you know how it goes.