Over night production

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Over night production

ChetMeinzer
What is the best method for running automatic process overnight on Windows (don't have SPSS server edition yet)?  I want

Currently
1. saving syntax in an 'insert file... error=stop'.
2. creating SPJ in production
3. running syntax in '.bat' as
   "C:\Program Files\IBM\SPSS\Statistics\21\stats.exe" -production "K:\path.spj"
4. task scheduler in windows.  

This works, but is there a good python solution or something with less steps?  

Reply | Threaded
Open this post in threaded view
|

Re: Over night production

Jon K Peck
You will need the Windows job scheduler regardless of what else you change (other than switching to *nix:-))  There is a Python scheduler module if you wanted to program the scheduling logic, but that is more for building a scheduling application.

You could put your syntax in a Python job and run it in external mode without creating a production job, e.g.,

myjob.py:
import spss
spss.Submit(r"""all the syntax
""")

Job to schedule
python myjob.py

External mode jobs can sometimes run significantly faster, because they don't have the UI to maintain.

You probably would want to wrap the syntax in OMS to save the output as an spv file or other format.

The syntax in the Submit could just be an INSERT command if you want to keep it separate.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: 720-342-5621




From:        ChetMeinzer <[hidden email]>
To:        [hidden email],
Date:        06/13/2013 02:47 PM
Subject:        [SPSSX-L] Over night production
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




What is the best method for running automatic process overnight on Windows
(don't have SPSS server edition yet)?  I want

Currently
1. saving syntax in an 'insert file... error=stop'.
2. creating SPJ in production
3. running syntax in '.bat' as
  "C:\Program Files\IBM\SPSS\Statistics\21\stats.exe" -production
"K:\path.spj"
4. task scheduler in windows.

This works, but is there a good python solution or something with less
steps?





--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Over-night-production-tp5720703.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD


Reply | Threaded
Open this post in threaded view
|

Re: Over night production

Rick Oliver-3
No need to wrap it in OMS. You can use OUTPUT SAVE or OUTPUT EXPORT in the syntax job to route output to SPV and other formats.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]




From:        Jon K Peck/Chicago/IBM@IBMUS
To:        [hidden email],
Date:        06/13/2013 04:17 PM
Subject:        Re: Over night production
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




You will need the Windows job scheduler regardless of what else you change (other than switching to *nix:-))  There is a Python scheduler module if you wanted to program the scheduling logic, but that is more for building a scheduling application.

You could put your syntax in a Python job and run it in external mode without creating a production job, e.g.,


myjob.py:

import spss

spss.Submit(r"""all the syntax

""")


Job to schedule

python myjob.py


External mode jobs can sometimes run significantly faster, because they don't have the UI to maintain.


You probably would want to wrap the syntax in OMS to save the output as an spv file or other format.


The syntax in the Submit could just be an INSERT command if you want to keep it separate.



Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: 720-342-5621





From:        
ChetMeinzer <[hidden email]>
To:        
[hidden email],
Date:        
06/13/2013 02:47 PM
Subject:        
[SPSSX-L] Over night production
Sent by:        
"SPSSX(r) Discussion" <[hidden email]>




What is the best method for running automatic process overnight on Windows
(don't have SPSS server edition yet)?  I want

Currently
1. saving syntax in an 'insert file... error=stop'.
2. creating SPJ in production
3. running syntax in '.bat' as
 "C:\Program Files\IBM\SPSS\Statistics\21\stats.exe" -production
"K:\path.spj"
4. task scheduler in windows.

This works, but is there a good python solution or something with less
steps?





--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Over-night-production-tp5720703.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD