p_file_20 won't run from crontab

• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
We used to run p_file_20 from the aleph crontab. Now this doesn't work. We can submit p_file_20 successfully from the command line and from the GUI client, but we would still like to be able to use crontab.

This is the error message we get from the crontab log:

get_ora_passwd: Command not found
get_ora_passwd: Command not found
unix_name: Undefined variable

Resolution:
cron" is not an Aleph function; this can be done equally well from the Aleph job_list.

In submitting the job from the command line, you are specifying a list of parameters like this:

ABC50,facadd.plif.10182008,facadd.rpt.10182008,Y,%,,,ALEPH_SEQ,

What you need to do is to create an entry in the $alephe_tab/job_list like this:

! 2 3 4 5 6 7
!!-!!!!!!!!-!-!!!!!!!!!!!!!!!!!!!!-!!!!!-!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!-!!!!!!
Wn hh:mm:ss Y ABC50 p_file_20 ABC50,facadd.plif.%DATE,facadd.rpt.%DATE,Y,%,,,ALEPH_SEQ,

where "Wn" the days you want to run it; "hh:mm:ss" is the time; and "%DATE" is today's date. {The input file suffix needs to be in the form 20081018 (-- not 10182008).}

If you are running the job in the early morning and the input file will have yesterday's date, you would specify: "%DATE-D001".

Note: If you paste the preceding lines into the job_list file (or Notepad), you will see that the parameters are in column 7.

• Article last edited: 10/8/2013