252543_en-US

liliconcom

JMP Script for SQL database access with an update rate of 2 minutes

Hi all,

i have a customer asking for the following: they have SQL data on a server with several datatables. They join these tables to analyse in JMP. The data is being updated on the server every 2 minutes. They would like to have the data as live as possible meaning to join and get extracted in JMP every 2 minutes in an automated way. Is it possbile. Any help is most useful.

Thanks a lot,

Cheers,

Valérie

Re: JMP Script for SQL database access with an update rate of 2 minutes

See Help > Scripting Index > Schedule function.

Re: JMP Script for SQL database access with an update rate of 2 minutes

Be aware if you use the Windows Task Scheduler the shortest duration for a scheduled task appears to be 5 minutes.

Repeat task every 5 minutesRepeat task every 5 minutes

 

However, this is not actually true.  You can type in the box and modify the default.

 

schedule task every two minutesschedule task every two minutes

 

cheers,

Stan

Re: JMP Script for SQL database access with an update rate of 2 minutes

My talk from Copenhagen discusses much of this, with use of the Windows task scheduler. Automated Report Creation: From Data Import to Publication ( 2019-EU-TUT-079 ) 

 

Brian