topic Re: Autorunning of JMP Scripts at a Specific Time in Discussions

Autorunning of JMP Scripts at a Specific Time

d_barnett — Wed, 29 Jul 2015 12:51:56 GMT

I have a set of scripts ( 7 in total) that I want to autorun at a specific time during the early morning so that the data is available to me when I get into work. All of these are saved as jsl files and I would like to queue these to run, these are stored on my hard-drive and JMP will be open and connected to a database..

Is there a way within JMP to do this? if I want to run these .jsl scripts to produce the data, some of these scripts extract large data sets from databases and can take ~30 mins to do so are very time consuming when I could be doing analysis ( and having my first coffee of the day).

As a build on to this t would also be good if I could use this for and JMP files ( .jmpquery in particular) to make it ultra useful.

Regards

David

Re: Autorunning of JMP Scripts at a Specific Time

msharp — Thu, 30 Jul 2015 22:43:42 GMT

What I usually do is create a .bat file then go to Task Scheduler to run the .bat file when I want it to.

Here's the basics of my .bat file. Just copy and paste it into a txt file and save the extenions as .bat. Change (***JSL FILE LOCATION***) to your jsl script file location and copy the line for all 7 scripts.

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

:: Batch file that runs all JSL scripts

:: ::

:: C:\logfile_source.txt is created to record results.

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

set logfile1=C:\temp\logfile_source.txt

"C:\Program Files\SAS\JMPPRO\12\Jmp.exe" ***JSL FILE LOCATION***

echo.JMP scripts have completed %date% %time% >> %logfile1%

Task Scheduler can be found Windows>All Programs>Accessories>Sytem Tools>Task Schedule. It's a pretty simple intuitive program. If you can't figure it out you can quickly find a tutorial on YouTube.

Re: Autorunning of JMP Scripts at a Specific Time

ian_jmp — Fri, 31 Jul 2015 08:58:58 GMT

If the JMP session is already active, you should also take a look at Scheduling Actions.