215798_en-US

liliconcom

Setting up ODBC Query to run daily

I am currently querying a couple of DB's using windows ODBC driver to read into JMP and eventually into a Data Table. I'd like to automate this process to update the DB and corresponding output scripts & Dashboards to run (for example) every day @ midnight.

 

Does anyone have any literature or reccomendations on how to do this?

 

Thanks all!

Re: Setting up ODBC Query to run daily

The first half of my tutorial from Discovery Summit Europe 2019 covers this topic: Automated Report Creation: From Data Import to Publication ( 2019-EU-TUT-079 ).

 

Brian Corcoran

JMP Development

Re: Setting up ODBC Query to run daily

JSL has a Schedule() function that will allow a script to be executed some number of seconds in the future.  See "Scheduling Actions" in the Scripting Guide for details.

     Help==>Books==>Scripting Guide

Re: Setting up ODBC Query to run daily

A small While loop who will execute once the day of year (atmidnight) changes

runtime_limit is a small fail_save to abord the loop.

 

Names Default To Here( 1 );

stop_command = 0;
try(win1<<CLOSE window="">runtime_limit,stop_command = 1;beep();throw("runtime limit reached"));
 wait(1); // execute every X secconds
 
 if(D_year != day of year(today()),
  // Execute Code
  print(i);
 );
 D_year = day of year(today());
 
 tb1 << set text("Date: " || Format( Today(), "d.m.y h:m:s" ));
);</CLOSE>