How to Schedule JSL and Python Scripts Sequentially in JMP 19

[#1]

"I am a JMP 19 user. I would like to automate a JSL script to run every morning at 7:00 AM, which fetches data from Oracle via ODBC, updates the data table, and saves it as an .xlsx file. Subsequently, I want to execute a Python script at 8:00 AM that imports that .xlsx file, performs various operations, and sends the results via email. I already have both the JSL and .py files—how can I automate this entire workflow?"

[#2]

If you are using Windows you could use Task Scheduler

[#3]

I’m already aware of that, but for some reason, it’s not working on my PC. Are there any other ways to handle this?

[#4]

First I would try to figure out what is the issue with Task Scheduler. Next I would try to google some trustworthy scheduling options. I have no proper recommendations as I have been fine with Task Scheduler or different Python based orchestrators for scheduling Python ETL.

[#5 · Accepted solution]

Hi Ronaldo,

Generally you need Admin privileges to run scheduled tasks on Windows if the operation works outside of your user folders. You will likely need "Log on as a batch job" permission as well.  If your IT group won't give you permissions for this, you can start JMP manually and try to use the Schedule function in JSL, but that may constrain what you can do to within the JMP session.

Brian Corcoran

JMP Development

[#6]

There are quite a few Q&A on this site about task scheduler on win. 

You should not try to use the JMP scheduler function for an app that needs to run long term; you need something like the OS task scheduler that will restart when the machine restarts. I think some of the Q&A may have been about how to get a started-but-not-logged-in machine to run JMP.

JMP can be started from the command line with a .jsl file to execute, and that is probably what you want from the win task scheduler.

[#7]

I'm using a simple method:

Run it at a scheduled time in AutoHotkey because I have a large AHK that runs as soon as the AutoHotkey boots up.

AutoHotkey is so useful.