SQL Server work load

[Geoka]

I have some sql script(complex), which will take too much time because of the data. It has to run on a daily basis. I have scheduled this for every morning,at the same time some other sql scripts are also execute in the same server. So my sql script timed out mostly. It will run some days perfectly. Is there any way to identify the sql server status like free/capable to run my scheduled script etc?

In short:
1. I would like to run a big query on a daily basis
2. Before execute query, i need to check whether the the sql server is busy or not.Or how much % the server is busy.
3. I would like to execute my script if the server is ready or enough capacity to run my script.

Thanks in advance.
George

 

[jrbarnett]

Could you reschedule it to run at a time when other things aren't running?
Alternatively could it be rewritten to work on smaller chunks of the data over a timespan so all is covered but not together?

John