Scheduling a job

[mab_arif16]

Hi
A sequence needs to be fired every hour by cron tab ,but some times it takes more than one hour for sequence to run ,so when the cron tries to fire it again while its still running I get a warning DS.SCHEDULE;Job Must be reset before run
Does somebody have any idea how to get around this problem.The sequence has to be fired every hour

Thanks
Arif

[ray.wurlod]

What do wou want to do if it's still running?

If you want to abandon execution for that hour, simply detect its current status and, if it is DSJS.RUNNING, simply don't issue the run request.

If you want it to run every hour irrespective of whether it's currently running, then your solution must involve multi-instance jobs. You can use the time, or a timestamp, as the invocation ID.

[chulett]

A sequence needs to be fired every hour by cron tab

Every hour, or very hour by cron? Cron in and of itself is not sophisticated enough to handle that situation. You'll either need to handle it as Ray notes, or use an Enterprise scheduler (like Control-M) rather than cron if you have one.