cancel
Showing results for 
Search instead for 
Did you mean: 

List all Job definition, Job Chains and Schedules.

Former Member
0 Kudos

Hi All,

I am having few doubts,

1. I need a list of job definitions and Job chains from all the queues with schedule details. Is there any sql query available to get this data. From UI, I am not able to acheive this. Please help.

2. Can any one explain what is Overdue status and in which case it will happen.

I am working on collecting reports from CPS. It would be better if you give some fair idea on DB table details. So that we can query and take.

Regards,

Muthukumar

0 Kudos

Hey Muthu , I am looking for the same, did you find a script for it ? or do you have any insights on how to perform this task.

moshenaveh
Community Manager
Community Manager
0 Kudos
Hello, While we're happy that you've come to SAP Community to get an answer to your question, you posted your question as a comment in an old thread.

If you're looking for help, you should ask a new question: https://answers.sap.com/questions/ask.html.
Here are some tips to help you craft an effective question for our community: https://community.sap.com/resources/questions-and-answers, https://developers.sap.com/tutorials/community-qa.html, https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a....
I encourage you to follow this guidance, as I'd really like to see you get a solution to your problem.
I hope you find this advice useful!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos


Hi,

Please use the attached script to extract the information of scheduled jobs.

Scripts that are not run within their time window are set to Overdue status

Regards,

Nanak

Former Member
0 Kudos

Thanks Nanak. I will try that script.

Regarding overdue status, still am not clear. My understanding is when the job is scheduled to run for every 15 minutes and the first schedule is runs for more than 15 mins. Next schedule which is missed is overdue??

Please explain. Thanks in advance.

Former Member
0 Kudos

Hi,

For example you have a job which is configured to run in the time window 9am to 11am and if the job didn't run by 11am due to some issue on the remote server, then the job goes to overdue status.

Regards,

Nanak

Former Member
0 Kudos

Thanks Nanak. While executing the script. I am getting the error. Can you please check and help on this.

Former Member
0 Kudos

Hi,

You need to make sure the queue exist. That's why it is throwing error. If you don't need the queue information, you can remove that part of the code and try running that script again.

Regards,

Nanak