Sending Job report to a file.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bala_135
Premium Member
Premium Member
Posts: 156
Joined: Fri Oct 28, 2005 1:00 am
Location: Melbourne,Australia

Sending Job report to a file.

Post by bala_135 »

Hello All,

I need to send my jobreport to a file.
I am using a after-subroutine DSobreport to do that.
I am passing the following as my input arument
1;c:\

I am getting the following warnings when I see the log in director.
routine..AfterJob (DoJobReport): Failed to open directory C:

Kindly help me how to do that.

Thanks,
Bala
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Try using a folder other than the root folder. Try referring to it with forward slashes, that is, as a UNIX-style pathname.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
bala_135
Premium Member
Premium Member
Posts: 156
Joined: Fri Oct 28, 2005 1:00 am
Location: Melbourne,Australia

Post by bala_135 »

Hello Ray,

Thank you for ur reply. I tried with the following options
1;C:\bala
1;C:/bala but i am getting the same warning.

Please let me know anything can be done about it.

Regards,
Bala
rkdatastage
Participant
Posts: 107
Joined: Wed Sep 29, 2004 10:15 am

Post by rkdatastage »

Hi bala

Can you please share the process steps u have followed to send the log

to a file or the code what u have written.

your sharing knowledge is highly appreciateble

thanks in advance

regards
RK
bala_135
Premium Member
Premium Member
Posts: 156
Joined: Fri Oct 28, 2005 1:00 am
Location: Melbourne,Australia

Post by bala_135 »

Hello RK,

These are the steps.
1.In the job parameter there is After sub-routine list.
Select the DSjobReport
If u see the routine in the manager u will understand what it does.
In the Input value pass the file type,directory path.this is where is my problem.I do not understand how to pass or where to pass the inputArg.Kindly share if you find some way.

Thanks,
Bala
rkdatastage
Participant
Posts: 107
Joined: Wed Sep 29, 2004 10:15 am

Post by rkdatastage »

Hi
Just pass the Report type as 0 / 1 / 2 followed by semicolon and give a directory path where the report file will be created

ex : select the dsjobreport as to execute after job subroutine
in the input value textbox : 3;c:\src


this is working fine

Regards
RK
bala_135
Premium Member
Premium Member
Posts: 156
Joined: Fri Oct 28, 2005 1:00 am
Location: Melbourne,Australia

Post by bala_135 »

Hello,

Thanks its working fine.Do we have any method to make all the logs of a job appending in a file.Kindly let me know.

Thanks
Bala
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No. The logs of a job are kept in a table.

You can create your own; search the forum for information on how to do this.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply