Hi all

In my Database server Some sceduled jobs are not running
How to check what are causes.

Example:

I secduled job (backup) at 12:00 but it failed
backup was not initiated at that time
how check the what is problem


Tahnks & Regards

What is your DB2 version and OS? Is the DAS running?

Andy

Need more info -
Are you using Task Manager or OS Scheduler?
What does your scheduled task do?
Is your scheduled task purely T-SQL or is it made up of scripts?
If you are talking about scheduling backups, are you defining the job in the automatic maintenance window?

HI

db2 8.2 and AIX 5.2 are versions of database and OS
we are using crontab to scedule jobs

Do the cron log messages show that it is trying to execute the scripts?

Which user is executing the scripts? Does it have the correct rights and configurations?

Andy

so its not a database issue and is an AIX issue..... try googling cron or maybe you cn ask the same question in some AIX forum for faster resolution.

cron jobs run with the correct user-id, but practically without any environment.
Try adding a line like
. $HOME/.profile
at the beginning of the shell script that is started from crontab.
This should set DB2DIR, DB2INSTANCE, INSTHOME etc.; I'm assuming these are set through your .profile file. Typically, that file will have a line something like
. /data/udb/db2sysa/sqllib/db2profile
Adding that line to the cron script (instead of $HOME/.profile) should also work.