ESP dSeries Workload Automation

 View Only
  • 1.  D Series

    Posted Feb 18, 2020 02:37 PM
    Hi,

    I have created a SQL Job Type where I am running the below SQL command to get the count. 

    select count (*) from Table.

    The LStatus is displaying the Output COUNT(*)=XXX.  

    What oprions do I have to query the actual value "XXX". I need to display this information in another application. Can I query the DE Series Database to retrieve this value. What options do I have?

    Thanks,

    Arnab


  • 2.  RE: D Series
    Best Answer

    Broadcom Employee
    Posted Feb 19, 2020 01:52 AM
    Hi,

    Can you please look into Job output variables  to check if that can help here. Can you please take a look at the example for SQL job that is documented below -

    https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/ca-workload-automation-de-web-client/12-2/scheduling/defining-and-managing-workload-objects/workload-objects/job-output-variables/sql-jobs.html

    - Ravi Kiran


  • 3.  RE: D Series

    Broadcom Employee
    Posted Feb 19, 2020 01:55 AM
    Hi,

    dSeries is now having a different community -https://community.broadcom.com/enterprisesoftware/communities/communityhomeblogs?CommunityKey=01f9af04-bcec-4c48-8697-829ab833175a

    Please bookmark this location and add your questions to that community going forward

    - Ravi Kiran


  • 4.  RE: D Series

    Community Manager
    Posted Feb 24, 2020 09:49 AM
    I will move this to the dSeries community

    ------------------------------
    Diane Craddock
    Community Manager, Broadcom Enterprise Software Division
    Broadcom Inc.
    ------------------------------