November 21, 2002 at 11:18 am
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.
November 21, 2002 at 6:01 pm
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
November 22, 2002 at 4:57 am
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.
November 22, 2002 at 9:26 am
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