Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Cron job not getting yesterday's date

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Cron job not getting yesterday's date
# 1  
Old 09-18-2010
Cron job not getting yesterday's date
I have this script that gets yesterday's date which runs fine whenever I call it. But when I set this script to run as cron job on 17/9, I noticed that on 18/9, 19/9 it returned the yesterday's date as 2 days' ago date.

on 18/9, yesterday's date was returned as 16/9
on 19/9, yesterday's date was returned as 17/9
on 20/9, yesterday's date was returned as 18/9

What went wrong? please help, thanks.
Last edited by viviensiu; 09-20-2010 at 01:06 AM..
# 2  
Old 09-18-2010
post the date logic that is in the script. also, what time is it scheduled to run in cron?
This User Gave Thanks to frank_rizzo For This Post:
viviensiu
# 3  
Old 09-19-2010
And the operating system?
This User Gave Thanks to edfair For This Post:
viviensiu
# 4  
Old 09-19-2010
And the timezone?
# 5  
Old 09-20-2010
Date logic: yest=$(TZ=aaa24 date +%y%m%d)

Operating system: AIX

Cronjob settings:
0 4 * * * ksh /scripts/getyest.sh

---------- Post updated at 09:04 PM ---------- Previous update was at 08:58 PM ----------

time zone: WAUST

---------- Post updated at 10:57 PM ---------- Previous update was at 09:04 PM ----------

hi guys, just an update, the script is getting 2 days' ago date instead of yesterday's date.

Job is set to run at 4am daily.
Last edited by viviensiu; 09-20-2010 at 01:03 AM..
# 6  
Old 09-20-2010
Suggest creating a cron at say 23:59 each day and recording the date in a file for later reference.
Failing that you'll need a script to do the date arithmetic or perhaps rethink the process.

The technique of adjusting TZ broadly works if the server base time is UTC and the timezone is GMT. There was post on this site recently where it misbehaved in India time.
This User Gave Thanks to methyl For This Post:
viviensiu
# 7  
Old 09-22-2010
problem solved. aaa24 is getting UTC as a timezone, where the server is using UTC-8. I changed the code to aaa16 instead and it's working.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script to compare two files of todays date and yesterday's date

hi all, How to compare two files whether they are same are not...? like i had my input files as 20141201_file.txt and 20141130_file2.txt how to compare the above files based on date .. like todays file and yesterdays file...? (4 Replies)
Discussion started by: hemanthsaikumar
4 Replies

2. Shell Programming and Scripting

Cron job - Need to run Cron every quarter at particular time

Hi, 1) If some job supposed to run on 1st of every month at 7 AM In cron job when we have a blackout on the 1st ( i.e when 1st falls on a sunday ) how can we make the job run the next business day? 2) How can we run a job on 25th of every quarter 7 AM(jan,apr,jul,oct) And if 25th... (5 Replies)
Discussion started by: System Admin 77
5 Replies

3. Shell Programming and Scripting

How to append date to filename, but base it on yesterday's date?

Hello, I'd like to write a monthly archive script that archives some logs. But I'd like to do it based on yesterday's date. In other words, I'd like to schedule the script to run on the 1st day of each month, but have the archive filename include the previous month instead. Here's what I... (5 Replies)
Discussion started by: nbsparks
5 Replies

4. Shell Programming and Scripting

How to get tomorrow,yesterday date from date Command

Hi I want to get tomorrow and yesterday date from date command. My shell is KSH and server is AIX. I tried several options, but unable to do. Please help on this. Regards Rajesh (5 Replies)
Discussion started by: rajeshmepco
5 Replies

5. Shell Programming and Scripting

Cron Job - date command problem

Hi I have one problem with cron job in Control Panel. I have a log file that is created once a day on another server and I need to transfer it in an exact time to my server so I wrote the cron job for it BUT the problem is in the date command: /filelog-`date +%Y-%m-%d`.tar.gz; The file... (1 Reply)
Discussion started by: bobo_balde
1 Replies

6. Shell Programming and Scripting

[Solved] Replace yesterday date with today's date except from the first line

Hello, I have a file like this: 2012112920121130 12345620121130msABowwiqiq 34477420121129amABamauee e7748420121130ehABeheheei in case the content of the file has the date of yesterday within the lines containing pattern AB this should be replaced by the current date. But if I use... (3 Replies)
Discussion started by: Lilu_CK
3 Replies

7. Shell Programming and Scripting

Need help in Shell Script comparing todays date with Yesterday date from Sysdate

Hi, I want to compare today's date(DDMMYYYY) with yesterday(DDMMYYYY) from system date,if (today month = yesterday month) then execute alter query else do nothing. The above requirement i want in Shell script(KSH)... Can any one please help me? Double post, continued here. (0 Replies)
Discussion started by: kumarmsk1331
0 Replies

8. Shell Programming and Scripting

get system date, format it, pass it as a parameter to a perl script - all in cron job

I am trying to get the string containing date - in a specfic format actually, although I think that part is inconsequencial - 1110226^1110226^1110226^1110226^1110226 - through echo or printf or in some other way - created within a cront job and passed as a parameter to a perl script. Now, I know... (3 Replies)
Discussion started by: v8625
3 Replies

9. Shell Programming and Scripting

Compare date from db2 table to yesterday's Unix system date

I am currently running the following Korn shell script which works fine: #!/usr/bin/ksh count=`db2 -x "select count(*) from schema.tablename"` echo "count" I would like to add a "where" clause to the 2nd line that would allow me to get a record count of all the records from schema.tablename... (9 Replies)
Discussion started by: sasaliasim
9 Replies

10. Shell Programming and Scripting

yesterday date month/date

Hi expert, I want to retrieve yesterday su log. How to calculate and assign variable value ( 06/23 ) in myVariable ? #!/bin/sh myVariable=yesterday date in month/date cat /var/adm/sulog | grep $myVariable > file.txt many thanks! (5 Replies)
Discussion started by: skully
5 Replies
Login or Register to Ask a Question