automating GJAPCTL jobs

 Problem Description : 

How to set up a job to automate TGRAPPL in GJAPCTL

 Resolution : 

1. Created the following autojob_tgrappl.sql and autojob_tgrappl.shl in /home/banmgr on Dino.

.shl

sqlplus autojob/password @autojob_tgrappl.sql

.sql

$ more autojob_tgrappl.sql

COLUMN nextjob NEW_VALUE oneup

select

 general.gjbpseq.nextval nextjob

from

 dual;

/

insert into gjbprun

select

 gjbpdft_job,

 &oneup,

 gjbpdft_number,

 sysdate,

 gjbpdft_value,

 null

from

 gjbpdft

where

 gjbpdft_job = upper('TGRAPPL')

and gjbpdft_user_id = upper('AUTOJOB')

/

commit;

 host /gdn01/prodhome/links/gjajobs.shl TGRAPPL P autojob password &oneup NOPRINT

2. You need to then log into Banner as the autojob user. go to GJAPCTL and enter the process you want automated. Enter all paramaters you wish to use. Then click hold and save the paramerts with no parameter set.

3. I then set up a proces on vulture that will ftp the files down to the N:\dept\banner_auto_logs folder. 

 Revision Date : 4/17/2012