static void MKChangeBatchStatus(Args _args)
{
batchJob batchJob;
while select forupdate batchJob
where batchJob.Status == BatchStatus::Waiting
{
ttsBegin;
batchJob.Status = BatchStatus::Hold;
batchJob.update();
ttsCommit;
}
}
{
batchJob batchJob;
while select forupdate batchJob
where batchJob.Status == BatchStatus::Waiting
{
ttsBegin;
batchJob.Status = BatchStatus::Hold;
batchJob.update();
ttsCommit;
}
}
No comments:
Post a Comment