Unix: Check Crontab Modification Time

(1)

 [root@db2prd603 ~]# ls -lrt /var/spool/cron/

total 8

-rw-------. 1 1665466707 domain users    0 Oct  7  2024 map96

-rw-------. 1 root       root                     1662 Nov 26  2024 prd1ins1

-rw-------. 1 db2admin   db2iadm1     1340 Dec  9  2024 db2admin




(2) 
[root@db2prd603 cron]# stat /var/spool/cron/db2admin
  File: /var/spool/cron/db2admin
  Size: 1340            Blocks: 8          IO Block: 4096   regular file
Device: 802h/2050d      Inode: 50495680    Links: 1
Access: (0600/-rw-------)  Uid: ( 1002/db2admin)   Gid: ( 1003/db2iadm1)
Context: unconfined_u:object_r:user_cron_spool_t:s0
Access: 2025-06-22 09:50:55.848724797 -0500
Modify: 2024-12-09 10:13:33.904942888 -0600
Change: 2024-12-09 10:13:33.905942976 -0600
 Birth: 2024-12-09 10:13:33.904942888 -0600



(3) log file:
[root@db2prd603 cron]# ls -lrt /var/log/cron
-rw-------. 1 root root 257299 Jun 22 09:56 /var/log/cron



[root@db2prd603 cron]# grep db2admin /var/log/cron



Comments

Post a Comment

Popular posts from this blog

Oracle: To clean up WRI$_ADV_OBJECTS

 set linesize 200; select segment_name, segment_type, bytes from dba_segments where tablespace_name='SYSAUX' order by bytes asc; COL OCCUPANT_NAME FORMAT A30 SELECT OCCUPANT_NAME,SPACE_USAGE_KBYTES FROM V$SYSAUX_OCCUPANTS ORDER BY SPACE_USAGE_KBYTES DESC; COL SEGMENT_NAME FORMAT A30 COL OWNER FORMAT A10 COL TABLESPACE_NAME FORMAT A10 COL SEGMENT_TYPE FORMAT A15 SELECT * FROM (SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME,BYTES/1024/1024 "SIZE(MB)",SEGMENT_TYPE FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='SYSAUX' ORDER BY BYTES DESC) WHERE ROWNUM<=10; 1.  automatic clean-up default 31 days           SELECT dbms_stats.get_stats_history_availability from Dual; 2. modify retention policy        exec  dbms_stats.alter_stats_history_retention (14); 3. a manual cleaning  exec dbms_stats.purge_stats (sysdate-14);   ALTER TABLE WRI$_ADV_OBJECTS MOVE; ALTER INDEX WRI$_ADV_OBJECTS_IDX_01 REBUILD; ALTER INDEX WRI$_ADV_OBJECTS_IDX_02 R...
Read more