Identify jobs modified or created after a point of time

[csri]

Hello,

I need your input on this. We have two DataStage servers with same version (DataStage server 7.5 on windows). Background is, we have been using Server A and created a new environment on server B same as server A and copied all the projects to server B. From this point on, we have modified few existing jobs and created new once on server B. Now, we want to keep only server A and I have to sync up server A with B. We do not have any version control or anything.

Is there a way to identify what jobs were modified or created on server B after the projects were created and jobs were imported from erver A.

Any input is appreciated.

Thanks.

[ray.wurlod]

Yes, via the DS_AUDIT table on Server B.

[csri]

Yes, via the DS_AUDIT table on Server B. ...

Thanks Ray. I have searched the forum on how to use DS_AUDIT table in a job. Created a q-pointer with q-pointer name as ds_audit_qp and account as localuv and filename as DS_AUDIT. But when I try to list the file using LIST ds_audit_qp, I am receiving Unable to open "ds_audit_qp" file. Can you tell me why am I receiving this and how can I delete the q-pointer from VOC. I would appreciate if you can provide me information on how I can use q-pointer in a job.

Thanks.

[chulett]

I don't see why you would need to create any kind of pointer. Access the table directly.

[csri]

I don't see why you would need to create any kind of pointer. Access the table directly. ...

Thanks a lot Craig. I was while reading different topics in the forum. It worked. Since, there is a q-pointer that I created, now I want to delete it.

Can you please tell me how can I delete a q-pointer created using SET.FILE command.

Thanks.

[chulett]

DELETE VOC 'Pointer Name' - and the quotes are required as far as I know.

[csri]

Thanks Craig. It worked.