on 01-22-2015 7:46 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jane,
Once you login into then on left hand side you will find the tab Definition click on that and then you will find the Report. Kindly refer below screenshot.
And in my previous comment I have mentioned the values for the Column field Name, Status, Date and Queue
Hope this will help you.
Regards,
Amarjeet Kamble
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.