In my project there is a requirement to load the job start time, endtime, status and records loaded to a audit table each time the job runs. Anyone who have done a similar job, could you please tell me how to do this.
If you have similar jobs, could you please send me the dsx of these jobs to jojipjohn@yahoo.com.
Yes this is true but the in built routine write these into a file. since the server is in windows I cabn not use shell script to grep the relevent information from this file and load it to database. Is there a way I can enter these information direcly to database
Ok. You can create your own sequential file and write data to this file after job completion and then in other job extract this data from file and load into database table..........Do all this in a sequencer.
Use code written in built in routine and customize it..... :D
Better create a new multiple instance job which get all information from DSGetJobInfo() and loads into audit table. Parameterize job name in Multi Instance job.... Which runs in sequence after main job....
