Making jobs in a sequence wait for specified time
Posted: Tue Nov 21, 2006 4:20 am
Hi Everyone,
I have a requirement in which i have no of jobs in a sequence.The first job in the sequence is comparing the data in one Sybase table with the data in one Oracle table.If the data in the Sybase table is having a higher timestamp than the data in the Oracle table then the rest of the jobs in my Sequence will be running.But if the timestamp of Oracle data is more than the timestamp of Sybase data then i am suppose to send an email and wait for 2 hours so that the Sybase table gets loaded with the latest data and i can run the rest of the jobs in the sequence. There is one exception to this logic,which is that during the wait process of 2 hours if the user gives a go ahead to the sequence it should run the rest of the jobs in the sequence,for example if after waiting for 1 hour the user gives a command for the running of the rest of the jobs then it should be done.
Can anyone please guide me on how i can do the waiting for 2 hours in the sequence in addition to the exception.
Thanks in advance,
I have a requirement in which i have no of jobs in a sequence.The first job in the sequence is comparing the data in one Sybase table with the data in one Oracle table.If the data in the Sybase table is having a higher timestamp than the data in the Oracle table then the rest of the jobs in my Sequence will be running.But if the timestamp of Oracle data is more than the timestamp of Sybase data then i am suppose to send an email and wait for 2 hours so that the Sybase table gets loaded with the latest data and i can run the rest of the jobs in the sequence. There is one exception to this logic,which is that during the wait process of 2 hours if the user gives a go ahead to the sequence it should run the rest of the jobs in the sequence,for example if after waiting for 1 hour the user gives a command for the running of the rest of the jobs then it should be done.
Can anyone please guide me on how i can do the waiting for 2 hours in the sequence in addition to the exception.
Thanks in advance,