I'm not aware of any sorting in WRKJOBSCDE other than the default by name. If sorting is needed, you might need to use the List Job Schedule Entries (QWCLSCDE) API to list the entries into a user space. You can then retrieve entries into whatever container you feel comfortable sorting or you can sort the space directly if you're comfortable with that.
You'll then need some form of display to view the items. If you only want to view the items and you retrieved the user space entries into a database file, you can probably get by with just a RUNQRY command.
You might consider a User Defined Table Function (UDTF) that does the whole job, calling the API and returning entries into a table format.
Tom
Discuss This Question: 3  Replies