We have integrations into MS 365 F&O that users are waiting to complete before they can take next steps and since we have many jobs running all day long, these jobs have to wait in line causing frustration for our users.
Is there any way within the Job Scheduler to override the fact that jobs simply stack up and are run when their turn comes up in the queue? I know we can create statements, but they do not get any special priority so while they are submitted at a precise time they still need to wait to run,
Is there a way to prioritize a job in the queue so it would take precedence?
Have you considered making the execution of jobs not single-threaded?