How to run an agent job in low priority

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pingx - 17 Mar 2008 23:51 GMT

Hi Sql server experts,

Is there a way that I can tell the agent to run a job in the lowest
priority(resource wise)? like Unix NICE command.

I need to solve this problem we are having ASAP. I appreciate any prompt
response.

Thanks in advance!

Pingx

Reply to this Message

Andrew J. Kelly - 18 Mar 2008 00:28 GMT

Not really. There is a feature in the next version of SQL Server called the
Resource Governor that will do this but not currently.

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

> Hi Sql server experts,
>
[quoted text clipped - 7 lines]
>
> Pingx

Reply to this Message

Pingx - 18 Mar 2008 01:37 GMT

Andrew, thanks for your help.

Pingx

> Not really. There is a feature in the next version of SQL Server called the
> Resource Governor that will do this but not currently.
[quoted text clipped - 10 lines]
> >
> > Pingx

Reply to this Message

Greg D. Moore (Strider) - 19 Mar 2008 04:37 GMT

> Andrew, thanks for your help.

What's your underlying problem and ultiamte problem?

There may be other solutions we can propose.

> Pingx
>
[quoted text clipped - 14 lines]
>> >
>> > Pingx

Signature

Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Reply to this Message