SMS Job Scheduling
CMxxxxJ FCxxxxJ ISxxxxJ SDxxxxJ SMxxxxJ SRxxxxJ MGxxxx SGxxxx Other

Create Datax Extract File

This job runs Data Express, executing a catalogued procedure to create an extract file.
Special Instructions This job is for SBCCE use only. <R> The Data Express catalogued procedure that is run in this process must meet the following requirements: <R> --The procedure must edit the name and location of the input file(s). <R> --The procedure must be catalogued with PROCEDURE ACCESS = '@'. <R> --The procedure must be catalogued with a password. <R> When creating this procedure, be sure to document the order in which you have specified the data elements to be used for run-time selection criteria. When scheduling this job, you will NOT see the data element names for which run- time selection criteria is to be entered. Instead, you are provided with up to 10 parameters (PARM01-PARM10) where you enter your selection criteria responses in the order you would enter them if you were to run the procedure online. <R>
Frequency On-request
Scheduling Restrictions None
Execution Time Anytime (O, B, P or I)
Job Completion Status JOBFAIL
Job Groups None
Job Dependency Prior to running this job, the Data Express procedure specified in the PROC-NAME parameter must be catalogued into the Data Express catalog in the group.account specified in the CATALOG-GRP, CATALOG-ACCT parameters.
Operator Instructions None
Estimated Run Time None
Recovery/Restart This job is restartable.


DX1-PROC-NAME Enter the name (1-10 char.) of the catalogued procedure to be run. (Required)
DX2-CATALOG-GRP Enter the name of the group (1-8 char.) of the Data Express catalogue from which the procedure is to be run. (Required)
DX3-CATALOG-ACCT Enter the name of the account (1-8 char.) of the Data Express catalog from which the procedure is to be run. (Required)
DX4-PROC-PASS Enter the password (1-8 char.) of the procedure to be run. (Optional). NOTE: If the procedure has been catalogued with a password, it must be entered.
Enter the responses necessary to provide selection criteria for the DATAX procedure. The responses must be entered in the exact order the DATAX procedure prompts for them. Review the procedure definition in DATAX to find the selection criteria sequence. Do not enter a response for selection criteria that have values imbedded in the procedure. For a 'SELECT ALL' response enter '@' rather than leaving it blank. A blank response will be ignored rather than being interpreted as 'SELECT ALL'. NOTE: You will not see the "SELECTED BY" data element names when scheduling this job.
SR9200-FILEGRP Enter the group where the output file is to be written. Valid values are GEN or RUN.
SR9200-FILENAME Enter the filename of the output file (from 1 to 8 characters, the first character must be alpha).

Distribution: SMS P999
Created: WED, JAN 04, 2012, 07:46 AM