Job info for a specific category
Posted: Tue Mar 23, 2004 10:52 am
Before I hurt myself, I thought I would ask the experts....
I would like to create a job that looks at a specific category in a project and will send an email if there are any jobs that are not in run-able order. Is there an easy way to do this?
Detail:
I looked at DSGetProjectInfo and can get a list of all jobs in a project, but category information is not given. I then looked at DSGetJobInfo, it gives all the information I need (such as DSJ.JOBSTATUS), but it also does not seem to give the category information. So, I could get the job status info for all jobs in a project (by looping through the DSGetProjectInfo list of jobs, attaching each one, and getting the job status). But is there a way to limit this to only one category in a project?
Thanks,
Scott
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
I would like to create a job that looks at a specific category in a project and will send an email if there are any jobs that are not in run-able order. Is there an easy way to do this?
Detail:
I looked at DSGetProjectInfo and can get a list of all jobs in a project, but category information is not given. I then looked at DSGetJobInfo, it gives all the information I need (such as DSJ.JOBSTATUS), but it also does not seem to give the category information. So, I could get the job status info for all jobs in a project (by looping through the DSGetProjectInfo list of jobs, attaching each one, and getting the job status). But is there a way to limit this to only one category in a project?
Thanks,
Scott
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users