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

Question

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

stan_koprowski · Answer

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 minutes

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

schedule task every two minutes

cheers,

Stan

briancorcoran · Answer

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

Mark_Bailey · Answer

See Help > Scripting Index > Schedule function.