Archives of the TeradataForum
Message Posted: Tue, 08 Jun 2010 @ 18:10:08 GMT
| Subj: || || Re: Parametrized Jobs |
| From: || || Leslie, Quincy |
Yes, Geoff and I worked together on a prototype for that very approach. We proposed REXX, but that was declined. Later, the model that was
approved and successfully deployed was straight JCL (Jobs/Procs/Parms). It utilizes object oriented TD/ANSI SQL under JCL, driven by passing a
Job ID as a message to the objects at runtime in the JCL Jobs. The jobs then query Master Data Management (MDM) tables residing on TD to morph to
the processes needed. We run over 2,000 such automated processes/day, 24x7x365 (we never close).