A report of all jobs

[Victor Swindell]

We've been running Atomic/UC4 for over decade...and people have come and gone.
Is there a can report of every job that exists in the system so that we can review/remove/catalog   all the jobs we have?

------------------------------
Victor C. Swindell
Programmer/Analyst III
Division of Information Technology
College of Charleston
Charleston, SC 29424-0001
P: 843.953.7522
[e-mail]
------------------------------

[Daryl Brown]

I don't think there's a canned report that offers this, but it would be a pretty straight-forward query of the OH table.

Are you literally looking for job objects only, or all objects?  What fields are you looking to display?

Here's a query for starters -- you can either run this directly, or execute it via a SEC_SQLI VAR:

select oh_client,oh_name,oh_otype
from oh
where oh_refidnr=0;

You can add "and oh_otype='JOBS' " to that SQL if you're literally interested in job objects only.

(NOTE: I don't know an easy way to include the path to an object in this query.  Has anyone figured out the right SQL for that?)

[Bernhard Flegel]

Hello Daryl,

for the path of an object - look at:

https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=3775f62b-57b9-4698-a5c1-bb0ef6c5a091&CommunityKey=2e1b01c9-f310-4635-829f-aead2f6587c4&bm=3775f62b-57b9-4698-a5c1-bb0ef6c5a091#bm3775f62b-57b9-4698-a5c1-bb0ef6c5a091

Best regards

Bernhard Flegel

[Victor Swindell]

I guess I want a list of ALL Jobs..with or without a schedule...and the possible owner
I'll try you query...but I'm not familiar with the UC4 Table Structure

thanks

------------------------------
Victor C. Swindell
Programmer/Analyst III
Division of Information Technology
College of Charleston
Charleston, SC 29424-0001
P: 843.953.7522
[e-mail]
------------------------------

[Daryl Brown]

If by "owner" you're referring to the user who created the object originally -- and I assume you're referring to all objects here, rather than JOBS objects specifically -- then try this:

select a.oh_client,a.oh_name,a.oh_otype,b.oh_name
from oh a, oh b
where a.oh_cruseridnr=b.oh_idnr;