sqlserver how to set job priority
- by Buzz
Is there any way to set one job priority higher then other,
In my case there are two jobs those are working on same set of tables,first JOB-A which is running every 12 hr and other JOB-B is every 10 minutes , i think at some time when they run simultaneously JOB-B is getting in to deadlock and get failed,
i google the topic and found sqlgoverner is helpful in such cases
does anyone know how to resolve?