March 19 1000 AM David Steger Batch Types Run my routine in background right now Run my routine in the evening or another day Run my group of programs when requested Run my programs on a regular schedule ID: 757801
Download Presentation The PPT/PDF document "Dynamic Batch Processing" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Dynamic Batch ProcessingMarch 19 10:00 AMDavid StegerSlide2
Batch Types Run my routine in background right now Run my routine in the evening or another dayRun my group of programs when requestedRun my programs on a regular scheduleOthers?Slide3
Batch Processing with 36.14 TodaySlide4
36.14.1 and 36.14.13Slide5
36.14.13Slide6
Dynamic Batch ProcessingSlide7
Dynamic Batch Processor
Batch Entries
Batch Parameter
Definitions
Dynamic Batch
Entries
+
=Slide8
Dynamic Batch Processor
Batch Entries
Batch Parameter
Definitions
Dynamic Batch
Entries
+
=
Standard QAD MFG/ProSlide9
Dynamic Batch Processor
Batch Entries
Batch Parameter
Definitions
Dynamic Batch
Entries
+
=
Date Formulas,
Operations,
Etc.Slide10
Dynamic Operations
Blank
Literal - the data entered in the value field
U
Unix Environment Variable: The
Unix
environment variable name is entered in the value field.
D
The date that is returned by the
Date Formula
that is entered in the value field
S
Substring of a value. Three parameters are entered in the value field:
P
Value of another parameter
MM
Month of a date returned by the
Date Formula
that is entered in the value field
DD
Day of a date returned by the
Date Formula
that is entered in the value field
Y2
Year of a date returned by the
Date Formula
that is entered in the value field - the 2 digit year is returned
Y4
Year of a date returned by the
Date Formula
that is entered in the value field - 4 digit year is returned
V
Value of another parameter. This is used when "
con-
cating
" the values of fields together.Slide11
Dynamic Date Formulas
EOM
End of Month
BOM
Beginning of Month
EOY
End of year
BOY
Beginning of Year
TODAY
Today's date
HI
QAD High Date
HIGH
QAD High Date
LO
QAD Low Date
LOW
QAD Low Date
LYD
Last year's date (this date, but last year)
EOQ
End of Quarter
BOQ
Beginning of Quarter
ECP
End of GL Calendar Period
BCP
Beginning of GL Calendar Period
PER
Period
Sun,Mon,Tue,Wed,
Thu,Fri,Sat
Select this day of this week
+n
Add n number of days
-n
Subtract n number of daysSlide12
Example 1: User Run BatchSlide13
Determine the ParametersSlide14
Determine the Parameters
Capture frame object
“a”Slide15
Determine the ParametersSlide16
Load the ParametersSlide17
Load the ParametersSlide18
Modify Static ParametersSlide19
Modify Static ParametersSlide20
Define Dynamic ParametersSlide21
Using Date Formulas
EOM
End of Month
BOM
Beginning of Month
EOY
End of year
BOY
Beginning of Year
TODAY
Today's date
HI
QAD High Date
HIGH
QAD High Date
LO
QAD Low Date
LOW
QAD Low Date
LYD
Last year's date (this date, but last year)
EOQ
End of Quarter
BOQ
Beginning of Quarter
ECP
End of GL Calendar Period
BCP
Beginning of GL Calendar Period
PER
Period
Sun,Mon,Tue,Wed,
Thu,Fri,Sat
Select this day of this week
+n
Add n number of days
-n
Subtract n number of daysSlide22
Using Date Formulas
EOM
End of Month
BOM
Beginning of Month
EOY
End of year
BOY
Beginning of Year
TODAY
Today's date
HI
QAD High Date
HIGH
QAD High Date
LO
QAD Low Date
LOW
QAD Low Date
LYD
Last year's date (this date, but last year)
EOQ
End of Quarter
BOQ
Beginning of Quarter
ECP
End of GL Calendar Period
BCP
Beginning of GL Calendar Period
PER
Period
Sun,Mon,Tue,Wed,
Thu,Fri,Sat
Select this day of this week
+n
Add n number of days
-n
Subtract n number of daysSlide23
Test the Formula
Today, BCP, -1, ECPSlide24
Define OutputSlide25
Run the BatchSlide26
Example 2: Scheduled BatchsSlide27
Dynamic Batch Scheduling
Queue Processor
Batch Schedule
Run Queue
(batches)
+
=Slide28
Dynamic Batch Scheduling
Queue Processor
Batch Schedule
Run Queue
(batches)
+
=
Run by cron:
DB, Queue, at HH:MMSlide29
Dynamic Batch Scheduling
Queue Processor
Batch Schedule
Run Queue
(batches)
+
=
Run this Queue on
Date, Hour, etc.Slide30
Key ScriptsbpschedThe batch processor script
bpsched is run on regular intervals each hour, up to once each minute. This script is executed by cron under the
crontab file for the userid batproc. bpsched checks the minute number (00-59) to determine which combination of queue and database to execute that specific minute.
schedpro2
bpsched
executes the script
schedpro2
.
schedpro2
can launch multiple instances of the batch processor based on the data in it's configuration file. The configuration file lists database and pf file combinations. Configuration files are stored in the system
batchproc
directory.
m9sched
schedpro2
executes
m9sched
for each database defined in the configuration file. The
m9sched
script executes the progress session which runs
t2bpstart.p
from the QAD menu. Slide31
What is a Queue? Configured in bpshedcase $M in
00) $BP -q Q00 -c live 15) $BP -q Q15 -c live
30) $BP -q Q30 -c live45) $BP -q Q45 -c liveesac Slide32
Dynamic Batch Output
Queue Processor
Batch Output
Processor
Run Log
and
createsSlide33
Dynamic Batch Output
Queue Processor
Batch Output
Processor
Run Log
and
creates
Text Output,
PDF Output,
Email to user, etc.Slide34
Define the Scheduled BatchSlide35
How the batch id can alter resultsSlide36
How the batch id can alter resultsSlide37
How the batch id can alter resultsSlide38
Other Operation Types
Blank
Literal - the data entered in the value field
U
Unix Environment Variable: The
Unix
environment variable name is entered in the value field.
D
The date that is returned by the
Date Formula
that is entered in the value field
S
Substring of a value. Three parameters are entered in the value field:
P
Value of another parameter
MM
Month of a date returned by the
Date Formula
that is entered in the value field
DD
Day of a date returned by the
Date Formula
that is entered in the value field
Y2
Year of a date returned by the
Date Formula
that is entered in the value field - the 2 digit year is returned
Y4
Year of a date returned by the
Date Formula
that is entered in the value field - 4 digit year is returned
V
Value of another parameter. This is used when "
con-
cating
" the values of fields together.Slide39
LogsSlide40
LogsSlide41
Future SOX EnhancementsError detection via keywordsEmail notification for job errorsEmail notification for report errorsBatch Run Access Restrictions
Group ID batproc can run all batch events“Submitted by” used to restrict users to their batch events
Enable/Disable extended to individual batch eventsNew “batch” or “background” events default to enableAll other new events default to disableSlide42
Dynamic Batch Processing