Rotine to write Job Log to File.

Basavan · Post by **Basavan** » Wed Mar 28, 2007 12:15 pm

Hi Guru's ,

I Have a req where i need a routine which can read jobname,directory path,start timestamp,End timestamp as Parameters.

This Routine should run monthly and capture all job log for past month(between the timestamp parameters) and write into a file and zip the file and also clear the log that was captured.

Can some body post if you have similar code that works for this req.

Thank You Very Much....!

kcbland · Post by **kcbland** » Wed Mar 28, 2007 12:25 pm

Routines don't run - jobs run. Your best option is to use the dsjob program inside a unix shell script.

Basavan · Post by **Basavan** » Wed Mar 28, 2007 12:30 pm

[quote="kcbland"]Routines don't run - jobs run. Your best option is to use the dsjob program inside a unix shell script. ...[/quote]

Thanks for quick responce Ken,

I could call that routine from sequencer right and shedule that sequencer job monthly.

Thanks Again

kcbland · Post by **kcbland** » Wed Mar 28, 2007 12:38 pm

You could, but why re-invent the wheel? Have you even looked at using dsjob?

Basavan · Post by **Basavan** » Wed Mar 28, 2007 12:49 pm

[quote="kcbland"]You could, but why re-invent the wheel? Have you even looked at using dsjob? ...[/quote]

Not Yet Ken....!

where could i find all diffrent options for dsjob.

Thank you.

kcbland · Post by **kcbland** » Wed Mar 28, 2007 12:53 pm

Search here!

Or, go to the DS Engine/bin and type dsjob, you can see all of the options. There's always the manuals under your Start button, there's lots of detail on the command line program there as well.