DSXchange

I need help to do the following:

1 job is to populate/refresh hash-files only 1x/day.

Can I have a logic that checks the recency of the hash-files, if they're > 24hrs old, open DB connection & re-create them.. otherwise just exit from the job without openning DB. this is due to slow DB performance for lookup.

cheers
HT

You need to check this before you run the job either in a routine or in batch job. You can open the file and use STATUS command to see how old it is or use a DOS or UNIX command like DIR or ls -l.

Your job that does it can emplace a flag, for example a record in a hashed file (SDKSequences would do). This record has a constant for its key, and the date as its non-key field. Look this up and proceed only if it's date is earlier than today's date.