Sort Date/Time in WRKJOBSCDE in AS/400

AOM

45 pts.

Tags:

AS/400

AS/400 administration

WRKJOBSCDE

How to sort by Date/Time in WRKJOBSCDE.

Asked: November 22, 2010 7:41 AM Last updated: November 24, 2010 4:20 AM

Answer Wiki

Last updated: November 22, 2010 4:56 PM GMT

CharlieBrowne62,340 pts.
History
Contributors
- Ordered by most recent
- CharlieBrowne62,340 pts.

Thanks. We'll let you know when a new response is added.

Unless there is some API to do this, you would need to output(*PRINT) and then have a program copy the report to a disk file and manipulate the data in that file.

Discuss This Question: 3 Replies

TomLiotta Nov 22, 2010 8:24 PM GMT

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

125,585 pointsBadges:

report
WoodEngineer Nov 23, 2010 5:05 PM GMT

This should do what you want: WRKJOBSCDE SEQ(*DATETIME) I am not sure when this option became available. We are running V5R4.

7,920 pointsBadges:

report
TomLiotta Nov 24, 2010 4:20 AM GMT

The SEQ(*DATETIME) is either the right answer or as close as it gets. Good catch. Tom

125,585 pointsBadges:

report