Is there a way to set the CPU usage of a query?

[Robbomobb]

I´ve created a query that consumes 100% of the CPU time when it executes and therefore i´ve scheduled it to run during off houres. Sometimes however, i need to run this query during daytime which brings the server to it´s knees and that is catastrophic since there are a lot of applications depending on this server.

So i wonder if there is a way to limit the query to use a fixed amout of CPU power, say 25%?

 

[hmckillop]

There is a database setting in enterprise manager called
"Use Query Governor to prevent queries exceeding a specified cost" but not sure about settingf this on a query by query basis

 

[Robbomobb]

Yes it seems like that property affects all queries run on the server. I´ll take it under consideration.

Thanks for the reply.