I am trying to get the "Full job description" (as seen in the properties dialogue of a job) from DS_JOBOBJECTS using dssh.
Currently I can get the "short Job description" which I know is field 4, but I need to get the long description which I believe is field 7.
I have been searching for multiple hours on this and as a result I am a bit frustrated and need a bit of spoon feeding. (I think this will be an easy one for you guys anyway)
So this is what I have so far:
Code: Select all
>SELECT DS_JOBS.NAME, DS_JOBOBJECTS.DESC FROM DS_JOBOBJECTS, DS_JOBS WHERE DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO AND DS_JOBS.NAME = 'TEST_000_MASTER' AND DS_JOBOBJECTS.@ID LIKE '%ROOT';
Job name............ Description.................................................
TEST_000_MASTER short
1 records listed.
>