updating a flag before and after running the sequences

[Swapnajali]

We have a requirement like we have to update a flag before and after running our sequences


Eg. The table structures is


SeqNo TableName Result

1 P1 50 ( If the result is 50 we will start our jobs and the run time we will update this table is 10 at that time other dependency jobs wont run)

2 P1 10 ( at the time of running)

3 P1 20 (after finishing we will update as 20) its



our requirement in this table seqno is primary key , its working for fine if only one sequence is running, we are facing the problem when we are running the two sequence at the same time its get the same max sequence number and try to put duplicate seqno. While picking the max sequence number I want to lock the table from other jobs access..

Thanks
Swapna

[chulett]

Looks just like this post:

http://www.dsxchange.com/viewtopic.php?t=111763

You really won't get better answers by posting it twice.