2 Replies Latest reply on Nov 1, 2013 11:00 AM by James Golden

    Scheduling extracts from a trigger

    James Golden

      Hello folks,


      We are looking to schedule refreshes based on a trigger of some sort, rather than use the server scheduler.


      For example, we have extracts currently scheduled for 9:00 AM; but out DW ETL runs late, and the table I need is not completely loaded until 9:30.  So, the schedule for 9:00 runs, but is not including all the data because the ETL was 1/2 hour late.


      We are looking for possible solutions, such as polling a windows folder looking for a current timestamp, which would then execute a tabcmd to refresh.


      Has anyone conducted similar procedures with success?  Any recommendations?