Skip to Content
avatar image
Former Member

To get the list of Job definition

Hi All,

I had a requirement to collect the list of jobs configured in CPS with the corresponding queue and schedule details. I had tried collecting through application wise, but it looks tedious.

We are using SQL DB for CPS. Can we get the about details directly through SQL query. If so, shall i get the table name to get this details.

Regards,

Muthukumar.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 22, 2015 at 05:35 PM


    Hello MuthuKumar,

    As sugested by H. Carpenter Please create the report "Definition --> Reports--> New Report".

    I am showing you to fetch the job list with the parameters JobDefinition, Status, Date and Queue. In the column add all these things mentioning proper field.

    For Name field is JobDefinition

    For Status filed is Status

    For Date field is ScheduledStartTime

    and for Queue field is Queue

    Then go to Selection tab and add you selections. Below I have added 2 selctions as jobdefinition should be in scheduled status and queue should be my selected one.

    Please specify the value of the each selction for Status value should be Scheduled

    And for Queue it should be your value of specific queue.

    Then SAVE and run the report you will get he job list with Job Definition, with Status Scheduled, With scheduled date and with the mentioned Queue.

    Hope this will help you.

    Regards,

    Amarjeet Kamble


    report.JPG (35.7 kB)
    selection.JPG (30.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi All,

      Shall i know what i have to select on the below screen.

      Also, the above mentioned fields are not available for me. Please find the below value what i did.

      Mentioned query filter as All Job Definitions in the below screen and Updated the Name field.

      Added a column Name as JobDefinitionType

      There is no field like status

      There is no field like ScheduledStartTime

      There is no field like Queue


      Also, I would more keen about to know DB structure, so that i can query can take. Any help will be appreciated.


      My CPS Version Details:


      SAP CPS Component version

      M33.87-66904

      SAP Net Weaver - 7.31 Patch 7

      CPS.JPEG (12.6 kB)
  • avatar image
    Former Member
    Jan 22, 2015 at 09:59 AM

    Hi Muthukumar,

    Simply create a report on Job. Select the columns you want.

    Look at "Definitions > Reports" - you can hit F1 to get help on reports once you are in the overview.

    Regards,

    HP

    Add comment
    10|10000 characters needed characters exceeded