Skip to Content
Apr 07, 2014 at 11:39 AM

Control on the release of the back ground jobs


Hello experts,

We have a requirement to process a set of jobs in sequence based on a sequence number.

It means the first set of jobs with sequence number 1 will all be released at once and they have to get finished for the next set of jobs with the sequence number 2 to get processed. Each job in a sequence will lock and update custom tables. Since certain jobs in a set has got more data they are consuming more run time and they keep the tables locked. Other jobs of the same sequence which try to update the tables are failing. Writing wait statement can be a performance and moreover we are not sure how much time to wait..Please suggest if we have any option to have the control on the release of jobs...