1 / 42

Dynamic Batch Processing: Scheduling, Execution, and Efficiency in Automation

Discover the capabilities of Dynamic Batch Processing with David Steger's insights. This session covers critical aspects, including running routines in the background, scheduling tasks, and executing batch jobs on demand. Learn to define dynamic parameters using date formulas and explore essential scripts like bpsched and schedpro2. Gain knowledge on configuring dynamic queues, generating output logs, and handling error notifications. Ideal for those looking to streamline batch processing in standard QAD MFG/Pro environments.

milly
Télécharger la présentation

Dynamic Batch Processing: Scheduling, Execution, and Efficiency in Automation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Dynamic Batch ProcessingMarch 19 10:00 AMDavid Steger

  2. 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 • Others?

  3. Batch Processing with 36.14 Today

  4. 36.14.1 and 36.14.13

  5. 36.14.13

  6. Dynamic Batch Processing

  7. Dynamic Batch Processor Batch Entries + Batch Parameter Definitions = Dynamic Batch Entries

  8. Dynamic Batch Processor Batch Entries Batch Parameter Definitions + Standard QAD MFG/Pro Dynamic Batch Entries =

  9. Dynamic Batch Processor Date Formulas, Operations, Etc. Batch Entries Batch Parameter Definitions + Dynamic Batch Entries =

  10. Dynamic Operations

  11. Dynamic Date Formulas

  12. Example 1: User Run Batch

  13. Determine the Parameters

  14. Determine the Parameters Capture frame object “a”

  15. Determine the Parameters

  16. Load the Parameters

  17. Load the Parameters

  18. Modify Static Parameters

  19. Modify Static Parameters

  20. Define Dynamic Parameters

  21. Using Date Formulas

  22. Using Date Formulas

  23. Test the Formula Today, BCP, -1, ECP

  24. Define Output

  25. Run the Batch

  26. Example 2: Scheduled Batchs

  27. Dynamic Batch Scheduling Queue Processor Batch Schedule + Run Queue (batches) =

  28. Dynamic Batch Scheduling Run by cron: DB, Queue, at HH:MM Queue Processor Batch Schedule + Run Queue (batches) =

  29. Dynamic Batch Scheduling Run this Queue on Date, Hour, etc. Queue Processor Batch Schedule + Run Queue (batches) =

  30. Key Scripts • bpsched • The 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.

  31. What is a Queue? • Configured in bpshed case $M in 00) $BP -q Q00 -c live 15) $BP -q Q15 -c live 30) $BP -q Q30 -c live 45) $BP -q Q45 -c live esac

  32. Dynamic Batch Output Queue Processor Batch Output creates Processor Run Log and

  33. Dynamic Batch Output Text Output, PDF Output, Email to user, etc. Queue Processor Batch Output creates Processor Run Log and

  34. Define the Scheduled Batch

  35. How the batch id can alter results

  36. How the batch id can alter results

  37. How the batch id can alter results

  38. Other Operation Types

  39. Logs

  40. Logs

  41. Future SOX Enhancements • Error detection via keywords • Email notification for job errors • Email notification for report errors • Batch 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 events • New “batch” or “background” events default to enable • All other new events default to disable

  42. Dynamic Batch Processing

More Related