Automic Workload Automation

 View Only

 Change Archive Key using DB Change

Peter Wong's profile image
Peter Wong posted May 11, 2025 09:50 PM

Hi all

We have a number of objects (JOBS, JOBP, SCRI, JSCH, SYNC) whereby we would like to replace the archive key1 and archive key2.

In these objects the values of archive key1 and archive key2 may be null or they may have value.

In my db change script, I have the following lines:

REPLACE *, *, *, ARCHIVE_KEY2, *, "new value"
REPLACE *, *, *, ARCHIVE_KEY1, *, "new value"

Michael A. Lowry's profile image
Michael A. Lowry

What is your question, Peter?