How to create a list of jobs by category

Pierre · Post by **Pierre** » Mon Sep 29, 2008 7:40 am

Hi,

I wrote a .bat file that creates a list of jobs by category in a csv file.
I would like to add to this file a column to indicate scheduled jobs.

Is there any simple way do do that (without redirecting "at" in a file) ?
I just need to know if the job is scheduled or not...

Thanks.
Pierre.

** Note: Subject changed to be more descriptive - Content Editor **

chulett · Post by **chulett** » Mon Sep 29, 2008 8:00 am

That information is only stored in 'at' so yes, you'll need to redirect and interrogate the 'at' schedule.

Pierre · Post by **Pierre** » Mon Sep 29, 2008 8:02 am

OK, thank you for your response.

Pierre.

venkatvelpula · Post by **venkatvelpula** » Mon Sep 29, 2008 8:21 am

Let me know, How did you do to get list of jobs?

chulett · Post by **chulett** » Mon Sep 29, 2008 9:18 am

dsjob with the -ljobs option, I would imagine.

vbarca · Post by **vbarca** » Tue Dec 30, 2008 12:59 pm

chulett wrote:dsjob with the -ljobs option, I would imagine.

dsjob with the -ljobs option will give you the list of jobs in a project but not by category as Pierre states he did. That is what I am looking to do.

Pierre, can you tell us how you got the list of jobs by category?

Thanks,
Vince

Pierre · Post by **Pierre** » Wed Feb 04, 2009 9:40 am

from my project dir (Ascential\Datastage\Projects\MyProject), I launch

!DirDSBin!\dssh SELECT CATEGORY FMT'80L', NAME FMT'80L' FROM DS_JOBS WHERE NAME NOT LIKE '\%%' ORDER BY CATEGORY, NAME; > OutputFile.csv

where !DirDSBin! is my Ascential\Datastage\engine\bin dir.