/
Dynamic Batch Processing Dynamic Batch Processing

Dynamic Batch Processing - PowerPoint Presentation

trish-goza
trish-goza . @trish-goza
Follow
371 views
Uploaded On 2019-03-19

Dynamic Batch Processing - PPT Presentation

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

batch date dynamic year date batch year dynamic field entered qad returned run queue processor beginning formula parameters high period today month

Share:

Link:

Embed:

Download Presentation from below link

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.


Presentation Transcript

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