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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-18 : 09:58:34
|
| Sean writes "Hello,We are using MSQL server 2000. We have a job that usually runs fine but about every 2 to 3 days the job gets stuck in the status: "Performing completion actions". We usually restart the server to fix the problem.Any ideas?Sean" |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-03-18 : 16:20:29
|
I remember experiencing a similar problem using the RTM version of SQL 2K. MSFT has a knowledge base article on it; SP1 fixed the issue ( if my memory is correct, anyway  )setBasedIsTheTruepath<O> |
 |
|
|
sthevoz
Starting Member
2 Posts |
Posted - 2002-04-17 : 06:58:13
|
| We have the same problem!Who can I find this article to solve the problem??Thank youSylvain Thevoz |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-18 : 02:41:15
|
| What is the job doing? Is it perhaps trying to insert a null value in a column that doesn't accept nulls?A reboot is not required, just stop/start SQLAgent.I don't see an article on this issue.-Chad |
|
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-04-18 : 09:50:08
|
| I don't think this is what you want, but I spent a few minutes looking through the SP1 fixlist and it was Q290077 that I had remembered.setBasedIsTheTruepath<O> |
|
|
|
|
|
|
Problems with a Job running.