I scheduled 2 Oracle jobs to run on IBM AIX 4.3.3 at
06:50 and 06:58 on 02/02/03 with the below syntax:

$ at 06:50 02/02/03 /orac/ora11/temp/sun_job1.sh
Job oracle.1044175800.a will be run at Sun Feb 2 06:50:00 2003.


$ at 06:58 02/02/03 /orac/ora11/temp/sun_job2.sh
Job oracle.1044176280.a will be run at Sun Feb 2 06:58:00 2003.


But I went back on the korn shell to double check the time the job will run using
"atq", it is giving me a different time. Can any one explain what's going on?

$ atq
oracle.1044175800.a Sun Feb 2 03:50:00 EST 2003
oracle.1044176280.a Sun Feb 2 03:58:00 EST 2003

Thanks,
Ted


NOTE:
My Server is on the EAST COAST of the US but the atp command seems to specify a west coast time.

Also when I type date from the kornshell. it gives me the date time in Eastern Standard Time

since you checked the necessary things you needed to check to verify why your system isn't scheduling the jobs at the desired time, i say you try scheduling the job another method.

It's been a while since I've done this but from what I remember, i know you can schedule at job times anyway you want.

for instance, you scheduled your at jobs like this:

at 06:50 02/02/03 /orac/ora11/temp/sun_job1.sh

try replacing the "06:50" with something else equivalent. I think you can replace it with words but am not sure. anyway, what am saying is, change the syntax of these current jobs so the new syntax is different but equivalent