find category name

[GJ_Stage]

Hi All,

dsjob -ljobs TEST

I can see all the jobs under project called TEST but Category name (Folder) is not displaying . I wanted to remove some jobs from this project but without folder name it is very difficult to do it. Every time i need to fire DS_JOBS command to find category.

select category from ds_jobs where job_name='firstjob'|

Please tell me is there any way is there to find list of jobs under each category in 7.5.2.

[ray.wurlod]

Code: Select all

SELECT NAME FROM DS_JOBS WHERE CATEGORY LIKE '%<<Category>>';

[GJ_Stage]

Thanks.

I wanted to take list of all the jobs and corresponding category in the project. What command need to use.?

[chulett]

Same "command", slightly modified.

Code: Select all

SELECT NAME, CATEGORY FROM DS_JOBS

You'll get a little extra stuff without excluding 'root records' and the like but that's close enough. Seriously, was that all that hard to derive from the other examples?

[ray.wurlod]

Code: Select all

SELECT NAME, CATEGORY FROM DS_JOBS WHERE NAME NOT LIKE '//%' AND NAME NOT LIKE '\\%' ORDER BY CATEGORY, NAME;

[chulett]

Left that extra bit for you, Ray.

[pandeesh]

Craig, What are that ''root records" actually ?

Thanks

[ray.wurlod]

Nothing to worry about. In fact, there are no ROOT records in DS_JOBS.

[chulett]

I guess those are actually in DS_JOBOBJECTS. I was referring to the bits Ray excluded with the "not like" syntax he added. Category records? Embedded henderson joints? Temporal fragments?

[ray.wurlod]

The excluded records are simply category placeholders - they record the existence and relationships of category folders. They contain no other information.