Page 1 of 1
find category name
Posted: Tue Aug 23, 2011 4:46 am
by 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.
Posted: Tue Aug 23, 2011 6:21 am
by ray.wurlod
Code: Select all
SELECT NAME FROM DS_JOBS WHERE CATEGORY LIKE '%<<Category>>';
Posted: Tue Aug 23, 2011 7:57 am
by GJ_Stage
Thanks.
I wanted to take list of all the jobs and corresponding category in the project. What command need to use.?
Posted: Tue Aug 23, 2011 8:02 am
by 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?
![Confused :?](./images/smilies/icon_confused.gif)
Posted: Tue Aug 23, 2011 3:04 pm
by ray.wurlod
Code: Select all
SELECT NAME, CATEGORY FROM DS_JOBS WHERE NAME NOT LIKE '//%' AND NAME NOT LIKE '\\%' ORDER BY CATEGORY, NAME;
Posted: Tue Aug 23, 2011 3:12 pm
by chulett
Left that extra bit for you, Ray.
![Wink :wink:](./images/smilies/icon_wink.gif)
Posted: Wed Aug 24, 2011 1:11 am
by pandeesh
Craig, What are that ''root records" actually ?
Thanks
Posted: Wed Aug 24, 2011 3:54 am
by ray.wurlod
Nothing to worry about. In fact, there are no ROOT records in DS_JOBS.
Posted: Wed Aug 24, 2011 5:59 am
by 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?
![Confused :?](./images/smilies/icon_confused.gif)
Posted: Wed Aug 24, 2011 3:49 pm
by ray.wurlod
The excluded records are simply category placeholders - they record the existence and relationships of category folders. They contain no other information.