How to generate a report of Control-M job which include all the variant parameters?

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Control-M/Server for UNIX and Microsoft Windows


    COMPONENT:

    Control-M/Server for UNIX and Microsoft Windows


    APPLIES TO:

    All version of BMC Control-M/Server for UNIX and Microsoft Windows



    PROBLEM:

     

    Problem:
    Unable to view the Control-M Job details for there is no Control-M Enterprise Manager ( EM ) / Workload Automation ( WLA ) GUI

    Questions:
    - How to generate a report of Control-M jobs to include all the variant parameters from the job definition without GUI?
    - How to list out all the all the variant parameters from the Control-M Module job definition using command line? For example SAP, PS etc
    - How to view all the all the Autoedit parameter of a Control-M Job using Control-M Server ctmpsm utility ?
     

     


    SOLUTION:

     

    Legacy ID:KA395138

      

    Solution:

      

    Option 1: Using Control-M/Server ctmpsm utility
    - Use Control-M/Server utility called ctmpsm to generate a report to list all the details of a Control-M Job
    - The following syntax will show all details including autoedit variables for any job on the AJF
      Usage: ctmpsm -LISTFULLDETAILS <orderid>

    Option 2: SQL option on Control-M Server or  Control-M Enterprise Manager database:
    - You can write a SELECT SQL query in consultation with your database administrator to generate the report.
    - Please note that BMC does not provide SQL queries and do not recommend any UPDATE SQL query on Control-M database.
    - However, you can contact BMC Support for a copy of the database model for the Control-M Database schema.
     

      
      

     


    Article Number:

    000080256


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles