Page 1 of 1

tricky job

Posted: Tue Aug 03, 2010 11:03 am
by koolsun85
hello everyone,


There is a tricky situation where jobs are running in production.
I need to build a job where i should get the count and the names of the jobs finished, aborted , finished with warning and not complied.

Thanks in advance.

Posted: Tue Aug 03, 2010 12:36 pm
by arunkumarmm
If you know the exact no. of jobs, you can achive this by having a master sequence. But not sure about the job in not compiled state.

Btw, what is the use of having jobs in not compiled state in PROD and also the count of them? how does that matters?

Posted: Tue Aug 03, 2010 12:48 pm
by koolsun85
they wanted to know the number of jobs
when i queried to find the number of jobs it says 1245 jobs
Its ok not to know the details of not compiled jobs...

Posted: Tue Aug 03, 2010 1:10 pm
by chulett
You need to build a job to do this or can you do something from the command line? I ask because you can script this using dsjob which can be simpler for people if they haven't done much work with the DSGet* API functions and BASIC.

Posted: Tue Aug 03, 2010 1:13 pm
by koolsun85
Can also do from the command line... replies welcome..

Posted: Tue Aug 03, 2010 1:21 pm
by chulett
Then look at the various dsjob options as noted, for example -ljobs to get a list of jobs then loop thru them and issue a -jobinfo for each one.

Posted: Tue Aug 03, 2010 1:39 pm
by koolsun85
I didnt get it right.. can u reply me with the full syntax.,...

Posted: Tue Aug 03, 2010 1:41 pm
by koolsun85
Details :

project name is : "ANWRM23

Posted: Tue Aug 03, 2010 4:24 pm
by chulett
The dsjob Command Line Interface is fully documented, plus has full 'usage' statements if you run it with missing arguments like any good UNIX command. So you need to do some research, as noted check on the following options:

dsjob -ljobs
dsjob -jobinfo


Between those two you'll get everything you need, I do believe.

Posted: Tue Aug 03, 2010 4:52 pm
by koolsun85
Thanks for reply, will post after searching

Posted: Tue Aug 03, 2010 5:50 pm
by kduke
Install EtlStats and save some time.