Setting priority of a SQL job

  • Can anyone assist me with setting the priority of a job that runs in SQL. I have a job scheduled but want to set it to a lower priority. I have found information on the OSRunPriority property but cant find how or where to set this value. If I can set it to -1 which is BelowNormal that would be great. Any help would be appreciated.

  • I don't have any experience using this so buyer beware... sp_add_jobstep has the property @os_run_priority which uses the priority system of -15 through 15. It's undocumented, I wonder if there's a reason.



    Everett Wilson
    ewilson10@yahoo.com

  • Specifically why do you need to lower the priority of the Job? Usually there are better solutions taht doing this and I am just curious.

  • I have a job scheduled that needs to run at a lower priority than the other scheduled jobs. This job is a non-interactive job and it shouldn't take priority over the other more important jobs. The job populates a local summary table from a remote database periodically. I'll take a look at the sp_add_jobstep SP and see what I can find. Thanks for the help guys. If you have any other ideas, I'm definitely open to suggestions.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply