Choose Language Hide Translation Bar
Highlighted
hmiles
Level I

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

View solution in original post

3 REPLIES 3
Highlighted
Mauro_Gerber
Level III

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;);
win1 = New Window( "Timer",
	V List Box(
		tb1 = text box("Date: " || Format( Today(), "d.m.y h:m:s" )),
		Button Box( "Cancel",
			stop_command =1;
			win1 << close window;
		)
	)
);
i = 1;
runtime_limit = 10; // max number of iterations of the loop
D_year = day of year(today());
while(!stop_command,
	i++;
	if(i>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" ));
);
"I thought about our dilemma, and I came up with a solution that I honestly think works out best for one of both of us"
- GLaDOS
Highlighted
txnelson
Super User

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

Jim
Highlighted

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

View solution in original post

Article Labels

    There are no labels assigned to this post.