Skip to content
Home » AIX » How to Resolve 0481-077 The date or time is either too large or too small

How to Resolve 0481-077 The date or time is either too large or too small

AIX Error 0481-077

Tried to schedule a job on Sunday in an AIX server, but it failed with 0481-077.

[oracle@test oracle]$ crontab -e
A line of the crontab file:
        0 1 * * 7 /home/oracle/export_schemas.sh > /dev/null 2>&1

contains the following error:
        0481-077 The date or time is either too large or too small.

It seems that the date time format of crontab is not acceptable by AIX 7.2. Please check the correct format and value range of a cron job for sure.

In Linux, the 7 can also be used to represent Sunday in the weekday field, because some people think the first day of a week should be Monday, not Sunday.

But it's not the case in AIX, Unix-based OS like AIX counts Sunday as the first day of a week. Let's see what IBM AIX 7.2 document says about crontab.

weekday 0 through 6 for Sunday through Saturday

That is, AIX error 0481-077 indicates that the format or value of a cron job is not acceptable, we should be aware of that it uses 0 to represent Sunday.

Solution

To solve the 0481-077 error, we should not use 7, instead, we should use 0 in AIX to make it run on Sunday.

[oracle@test oracle]$ crontab -e
...
0 1 * * 0 /home/oracle/export_schemas.sh > /dev/null 2>&1

We solved it.

Such error is very similar with a crontab error in Linux, you may have a look.

Leave a Reply

Your email address will not be published. Required fields are marked *