I want to store job information like Job Name, Job time before job started and after job ending(Succfuly or failure).
Kindly give in detail procedure to achive this task.(Ideal senario)
DataStage Job's auditing
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks for reply
Yes, We are using Operational console but it is not associated with databases.
Simply!!!
We have a table for job's auditing with our created additional information other than Job Name and time for our ease.
We need to implement this using Datastage job (Parallel or Sequence) and that Job is place before and after the orgional job in sequence Like:-
We need to do auditing without enable Operational Metadata.qt_ky wrote:Go into DataStage Administrator, open your project settings, and enable the option to collect Operational Metadata.
ray.wurlod wrote:If you are using DataStage Operations Console (and its associated database) this information is already being collected and stored.
Yes, We are using Operational console but it is not associated with databases.
Simply!!!
We have a table for job's auditing with our created additional information other than Job Name and time for our ease.
We need to implement this using Datastage job (Parallel or Sequence) and that Job is place before and after the orgional job in sequence Like:-
Job_StartTimeAudit------->Orgional Job---------->Job_EndTimeAudit
You can write a server routine using following list of functions :-
DSAttachJob, DSGetJobInfo, DSGetJobInfo, DSGetJobInfo, DSGetJobInfo
It will help you in getting all required Datastage jobs auditing values and then you can write all parameters in some place holder using "Call DSExecute" command.
Regards..!!
DSAttachJob, DSGetJobInfo, DSGetJobInfo, DSGetJobInfo, DSGetJobInfo
It will help you in getting all required Datastage jobs auditing values and then you can write all parameters in some place holder using "Call DSExecute" command.
Regards..!!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The Ops Console database is, typically, referred to as DSODB. It's fully accessible and fully documented (in the manual and in the IBM Knowledge Center). You ought to be able to get whatever you need directly from that database.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.