ERP Associates, Inc.

I received this e-mail this morning.  I sent a reply, but it bounced.  Since there might be other people who are interested in the answer or people who might have a better idea than me, I decided to post it here:

Hi Brent,

I would like to know if you can tell me how to automate Initial Alter Audit run when upgrading PeopleSoft.

Also do you know how to automate the whole process (peoplesoft or peopletools upgrade) ?

Thanks.

You can automate the whole process through change assistant.  With change assistant, you can:

1) Download the upgrade steps (called an upgrade template) from customer connection;

2) Import it into Change Assistant (then it's called an upgrade job);

3) Add, edit, or remove steps as necessary for your specific needs; and

4) Execute the job.

Change assistant launches each upgrade step with data mover, SQL, or app designer as necessary.  Each process instance is tracked for abnormal termination, and it scans each log file for errors before moving to the next job.

Change assistant will deploy flat files like SQR's and COBOL's on your file server, app server and process scheduler regardless of the OS. 

Change Assistant is somewhat involved to install. You might want to read my change assistant article and refer to PeopleBooks.

Automating the initial alter audit -- I don't see the advantage of automating just this one step, but change assistant can certainly build the project in app designer, build the audit script, and run the script in your SQL Tool.

If Change Assistant is an overkill for what you're trying to accomplish, you can build the alter audit project in app designer.  Then create a batch file to build the SQL script (using App Desinger command line flags) and and run the script using your SQL tool.

-Brent