Jobstatus list

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Jobstatus list

Post by admin »

Hello,

for better maintenance of our projects I need a list with the status (like
director) over all projects with following informations:

- project
- category
- job
- status

What is the best way to do this?

My first effort was reading UV.ACCOUNT -> connect to each project, get a jobhandle and call DSGetJobInfo. But how to leverage this? I think to use a cursor, but there is no cursor in UniBasic and for matread I need a static array. Any comments or solutions?

best regards,

Udo
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Where do you want to put the list? What you want to do is certainly possible in a loop in BASIC, with calls to DSGetProjectInfo and DSGetJobInfo functions. You can declare a dimensioned array or, probably more appropriately, use dynamic arrays. Or write the results into a hashed file or into a sequential file for subsequent processing.
Locked