Changing processing options on scheduled jobs

[scotto72]

Here's a puzzler for all you guru's out there:
Is there any way to change the processing options on the job scheduler at run time? Here's the situation:
I've got a bunch of different financial reports that need to be run twice a month (Approximately 40). One of the processing options is the period, which needs to be changed every OTHER time the job is run. Is there an easy way to do that, a hard way to do that, or am I just engaging in fanciful thinking? (I don't mind messing with BLOBS and stuff in the R983051 or whatever, just need to get a solution.) And failing that, is there a way to do the same through runube.exe? We're an NT/SQL shop here (See sig) and I'm VERY curious as this would save one of our people a pretty significant chunk of time (These reports get distributed across our company to various people and I'm trying to automate that as well.) Any help greatly appreciated, even if it's "Upgrade to XE" or "Wait for B9" or "Not a chance." Thanks in advance!

B7332 sp10.1 SQL7.0 NT 4.0 sp6a
ESU's: All prerequisites, JD5550

 

[louisf99]

I thought there was a bug in B733.2 where the scheduler would not work if
you were running reports that required processing options. The last I heard
the tools people in Denver said they knew of this problem but there was no
fix.
A fix could be a ube interconnect and have the user run one report that
calls the other 40 reports and passes the processing option variable from
the first report to each of the others as needed.


B733.2 sp11.2 as400

 

[scotto72]

Well, it does work but you have to be careful - the scheduler runs with the specs of the last version run no matter who ran it, so if Joe User runs the scheduled version and changes processing options, it bombs. Actually, I was thinking of the report interconnect option as well, but I'm more CNC than developer (But I do switch hats on occasion.) I'm probably going to take that route as it is seemingly the best one. Thanks for the suggestion, and I'll let everyone know how it turns out!


- Scott

B7332 sp10.1 SQL7.0 NT 4.0 sp6a
ESU's: All prerequisites, JD5550

 

[franck_blettner]

I've try to done this, but it was a little difficult. It exists a BSFN that
modify processing options, but this BSFN works only on interactive
application. I've try to use this bsfn in batch appplication without
success. My enterprise server is a unix server, perhaps this bsfn works on
nt enterprise server. Try to use the B9090001 bsfn.

My problem was the same than you. I want to generate delinquency letter and
i have to change the date in the processing options before launch the batch.
My solution was to create a new version of the batch to modify the date in
event rules, and to send by mail the delinquency letter to people concerned.


Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 63
E-mail : [email protected]

Current Version : OneWorld B7332 Oracle, RS600
Work on :
Oneworld B7321, B7331, B7332, XE
Platform, UNIX, AS400, NT
Database : Oracle, SQL, DB2



-----Message d'origine-----
De : [email protected] [mailto[email protected]]De la
part de scotto72
Envoyé : lundi 25 mars 2002 17:53
À : [email protected]
Objet : Changing processing options on scheduled jobs


Here's a puzzler for all you guru's out there:
Is there any way to change the processing options on the job scheduler at
run time? Here's the situation:
I've got a bunch of different financial reports that need to be run twice a
month (Approximately 40). One of the processing options is the period,
which needs to be changed every OTHER time the job is run. Is there an easy
way to do that, a hard way to do that, or am I just engaging in fanciful
thinking? (I don't mind messing with BLOBS and stuff in the R983051 or
whatever, just need to get a solution.) And failing that, is there a way to
do the same through runube.exe? We're an NT/SQL shop here (See sig) and I'm
VERY curious as this would save one of our people a pretty significant chunk
of time (These reports get distributed across our company to various people
and I'm trying to automate that as well.) Any help greatly appreciated,
even if it's "Upgrade to XE" or "Wait for B9" or "Not a chance." Thanks in
advance!

B7332 sp10.1 SQL7.0 NT 4.0 sp6a
ESU's: All prerequisites, JD5550

--------------------------
Visit the forum to view this thread at:
http://www.jdelist.com/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=31372
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE Developers mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+



Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 48
E-mail : [email protected]

 

[Scott_Filstrup]

Thanks for the help, I'll give it a try and see what happens!

Scott Filstrup
Systems Administrator, JD Edwards
Grande Communcations, Inc.
[email protected]
http://www.grandecom.com/





- Scott

 

[JRev]

What about copying the version into two separate versions with separate processing options that are run at different dates?

We have also run into problems with the Oneworld scheduler, and because of that we have been running a separate scheduling tool called ROBOT.

Just a thought.

Justin Revoredo
Amersham Biosciences
Piscataway, NJ
OW B7332 Coexistence SP11.1
AS/400 Oracle
Citrix/Fat
upgrading to Xe!

 

[Carl_Fisher]

We don't use the scheduler, but we do use RUNUBE and NT AT, which gives the same problem.

Solution:

1) Custom Version - lock out the Processing Options so NO ONE can change them at runtime - this ensures no unpredictable results, as previously mentioned both scheduler and RUNUBE use the Processing Options and Data Selection from the last run on the Enterprise.

2) Modify the version, add Event Rules to force in the Processing Options, example where the Period is required on a Finance report, do a get on the F0010 and retrieve reporting Period. You may need to be a bit clever, but most Processing Options can be calculated for Automatic reports, after all they are Scheduled each week or month because all the options remain the same, only dates and periods tend to change and they can be calculated.

We have lots of special versions for Scheduled reports and it works just fine.

OW733.3 Xe SP 14.2
Enterprise Server - Intel NT + Oracle 8.0.6
Client - Citrix TSE + 4 NT PC's for development