topic Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)? in Discussions

How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

Botzal — Fri, 09 Jun 2023 18:13:45 GMT

Hi All,

I'm trying to run batch file automatically every day when radio button -"run whether user is logged on or not" is selected and it doesn't work.
It works only when radio button "run with the user logged on" is selected.
Can you advise please?

Thank you

Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

SDF1 — Mon, 21 Mar 2022 12:25:02 GMT

Hi @Botzal ,

If you have a separate system batch file that can open a JSL file -- i.e. double click it, then you should be able to run the JSL file automatically. If the very first like of your JSL code is the following //! then once you save and close the file, if you double click it, then it runs the JSL code, but doesn't open the file for editing. If your batch file can open it, I believe it should work, but I have not tried that myself.

Hope this helps!,

Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

Botzal — Mon, 21 Mar 2022 12:54:30 GMT

Hi @SDF1
I know and understand your explanation, but that's not what I mean.
My intention was,
How I schedule the script (Using the task scheduler) that will run every morning even when I sign out of computer.
The JMP script should not work interactively.
Thanks

Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

ih — Tue, 22 Mar 2022 13:31:03 GMT

What does happen when you try to manually start the task with 'run whether user is logged on or not' checked. Does it show an error? Does JMP start and then close (you would need to watch the task manager as the window will not open)?

I sometimes need to uncheck everything on the conditions tab to fix some errors that looked like permissions issues.

Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

Botzal — Wed, 23 Mar 2022 09:19:22 GMT

Hi @ih ,

When I try to run it manually it opens a CMD and JMP process (in task manager) and it's stuck on running status.

In addition, I tried to uncheck everything in condition tab, it is still didn't work.
Do you have any other advice please?
Thx

Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

ih — Wed, 23 Mar 2022 12:08:50 GMT

Since JMP did start I would focus on your script. Perhaps start with something very simple like what is below. Remember all of your outputs need to be written to a file, you will not have access to any windows or reports opened by your script.

Run this interactively first and make sure you have access to write to the file, then delete the csv file and try running it through the task scheduler:

//!

dt = New Table( "Untitled",
	Add Rows( 1 ),
	New Column( "test", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [1] ) )
);

dt << Save As( "C:/test.csv" )

Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

Botzal — Thu, 24 Mar 2022 07:55:24 GMT

@ih

I tried to do this, it does not work
It also opens a CMD and JMP process (in task manager) and it's stuck on running status.

Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

jthi — Thu, 24 Mar 2022 08:58:39 GMT

Add

Exit(No save);

Quit(No save);

to end of the jsl script you try to run to close the JMP instance

Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

Botzal — Thu, 24 Mar 2022 09:14:20 GMT

@jthi,

of course, I added to the script... doesn't work.

Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

ih — Thu, 24 Mar 2022 11:44:10 GMT

To clarify, when you say it does not work, does that mean the file IS created when the task is set to run when the user is logged on and you manually start the task, and it is NOT created when set to run whether the user is logged in or not and you manually start the task?

Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

Botzal — Thu, 24 Mar 2022 13:23:56 GMT

Correct.
The script run and generates output when the "Run only when user is logged on" is selected,
and it is does not work when the "Run whether user is logged in or not" is selected.
In both options I start the task manually.

Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

Botzal — Wed, 30 Mar 2022 08:25:45 GMT

Hi @ih ,

I was able to run the above simple script automatically when the button "Run whether the user is logged on or not" was selected.
The solution to run it - I added /k in Task Scheduler - see below.

But when I try to run a complicated script (pulling data from the server and saving output on the server) It still does not work - It stuck on running status . any advise please?

Thank you

Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

ih — Wed, 30 Mar 2022 18:58:14 GMT

You might add some actions in your script help point you to the parts of your script that do not work. For example, you could add lines like this throughout your script:

Save Text File( "$TEMP/RunStatus - Finished defining functions.txt", "")
Save Text File( "$TEMP/RunStatus - Starting to download data.txt", "")
Save Text File( "$TEMP/RunStatus - Downloading data and starting transformations.txt", "")

Re: How to run a script automatically - Task scheduler cannot run batch file (run whether user is logged on or not)?

WebDesignesCrow — Thu, 31 Mar 2022 05:58:38 GMT

Hi @Botzal ,

I'm not sure what you are trying to do with both cmd & jmp file running at the same time.

I able to run my script during user log out/in at specific time will below flow;

-> Task scheduler run my JSL script run at specific time

-> the .jmp script open a cmd file (for IT to do some copy/paste JMP Results from local PC to intranet server)

//call IT cmd to copy the files to intranet server
RP = run program(
	Executable ("C:\ScriptJMPAutomation\MoveJMPFile.exe")
);
//set no save for auto taskscheduler
exit(nosave);

-> .cmd file close after running its script & .jmp file exit with no save.

The task scheduler .jmp will still show running unlimited time if I click it to manual run through Task Scheduler.

So I forced it to stop after 1 hour through the task scheduler setting.

Can check back the results after the "1 hour" done. It will show as "ready".

My report ready to view the next morning even though the PC is log-off during the script running.

I'm not sure if this is helpful but just to share how I did it.

Maybe you can also read below link for details.

https://docplayer.net/48888365-Syntax-overview-let-s-start-with-the-syntax-of-run-program.html