tricky job

[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.

[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?

[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...

[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.

[koolsun85]

Can also do from the command line... replies welcome..

[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.

[koolsun85]

I didnt get it right.. can u reply me with the full syntax.,...

[koolsun85]

Details :

project name is : "ANWRM23

[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.

[koolsun85]

Thanks for reply, will post after searching

[kduke]

Install EtlStats and save some time.