Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hub
Starting Member
5 Posts |
 Posted - 2011-01-20 : 23:10:57
|
Error in daily schedule in sql server as below If we manually execute the SP, that is no problem and the error is not occur every dayPlease assist. TQ |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2011-01-23 : 20:25:53
|
| I think it is a matter of system resources possibly being limited at the midnight hour sometimes. If the job does not absolutely have to run at that hour, I would change the scheduled time to something like 12:25am. Do you have other jobs that are running at midnight? |
 |
|
|
Hub
Starting Member
5 Posts |
Posted - 2011-01-24 : 03:03:07
|
| Yes, u are right.Beside this job, i do have other job to running at 12.01am.Do you mean that SQL not allow to parallel run mutiple job ? |
|
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2011-01-24 : 07:28:15
|
| Hub, SQL DOES allow multiple jobs to run parallel, yes. But sometimes there is contention for resurces. I'm only guessing that might be the problem. Try to find a window of time when no oter jobs are running and schedule it for that time to see if the job then is able to complete successfully over a period of several days.....John |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2011-01-24 : 16:11:59
|
| What job actually does?Is it result of http://support.microsoft.com/kb/875411 |
|
|
|
|
|
|
SQL Daily Task failed