Skip to Main Content
Return to Navigation

Using the Master Sequencer Utility to Create Master Sequencer Jobs

The master sequencer utility (Create_MasterSequence) enables you to create master sequencer jobs using delivered sequencer jobs as input. You will recall that sequencer jobs invoke and run other jobs. You can create a master sequencer job to invoke and run all the required sequencers that populate a specific fact table , or populate all fact tables for a given data mart, or all fact tables for an entire EPM warehouse.

For example, you can create a master sequencer job to automatically invoke and run 20 sequencer jobs from the Receivables mart. To do so, simply use the master sequencer utility to specify the 20 jobs you want to invoke, enter the applicable job parameters, and import the generated *.dsx file into your project.

The master sequencer utility is available in the following DataStage folder: Utilities\Job_Utils\MasterSequence\Create_MasterSequence.

Creating a Master Sequencer Job

To create a master sequencer job using the master sequencer utility:

  1. Identify the individual sequencer jobs you want to include in the master sequencer job.

    The ETL Lineage topic can help you determine which ETL sequencer jobs are required based on your needs. See Understanding the EPM Lineage Spreadsheets.

    Note: The master sequencer utility uses only sequencer jobs as input; please do not use server jobs as input. Also, the sequencer jobs you select should be compiled and ready for use.

  2. Copy the list of sequencer jobs and paste the names into a text file.

    Ensure that each job is entered on a separate line. For example, 

    SEQ_J_Dim_PS_D_DT_PATTERN_OWE
SEQ_J_Dim_PS_D_BUS_UNIT_PF_OWE
SEQ_J_Dim_PS_D_BUSINESS_UNIT_EX

    Note: The master sequencer job uses the text file as an input and reads the list of sequencer jobs from the file.

  3. Save the text file and specify the input file path (SRC_JOBPATH).

    The file path you specify should be local to the server; do not specify a path to a client machine.

    Note the file path of the text file for later use.

  4. In DataStage Director, navigate to the Master Sequencer Utility using the following navigation: Utilities\Job_Utils\MasterSequence\Create_MasterSequence.

  5. Select Create_MasterSequence and run.

    The Create _MasterSequence - Job Run Options window appears where the job input parameters are displayed.

  6. In the Parameters tab, use the Enter Source text file Name field to enter the file path for the text file you created in step three.

  7. Use the Enter Target File Path field to enter a location where you want the new master sequencer job (the output *.dsx file) stored.

    The file path you specify should be local to the server; do not specify a path to a client machine.

    The file path must have the *.dsx extension appended to it, for example, C:\MSEQ\Mseq01.dsx.

  8. Use the Enter the Jobname field to enter the name of the new master sequencer job.

  9. Use the Choose the Master Sequence Type field to specify the mode in which you want the sequencer jobs to be run.

    Valid values are Parallel or Sequential.

    Note: Ensure you select the proper mode for the sequential jobs included in the master sequencer. Only staging sequencer jobs can be run in parallel. Other dimension and fact jobs may have dependencies and, unless those dependencies are identified and managed accordingly, we advise that you do not run them in parallel.

  10. Click the Run button to generate the master sequencer job.

    This process generates the master sequencer job and stores it in the target file path you specified in step seven.

  11. Check the log file of the Create_MasterSequence job for warning messages

    Hard-coded values in the sequencer job parameters are listed as warning messages in the log file. If you encounter a warning message, correct the master sequencer job parameters accordingly, and re-run the Create_MasterSequence job.

  12. Import the generated master sequencer job into your DataStage project.

    If a master sequencer job with the same name already exists in the project, it is overwritten and placed in the same category.

    If the master sequencer job does not exist in the project, it is placed in the following default location: Utilities\Job_Utils\MasterSequence.

    Once the master sequencer job is imported into your project, you can move it to another category.

    The utility does not provide annotations for the master sequencer job, but you can provide annotations if you wish.

Note: You must compile the master sequencer job before you can use it.

See Compiling ETL Jobs.