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-08-27 : 11:32:46
|
| Neelesh writes "HiI am using SQL Server 7.0 with Service Pack 3.On my SQL server one job is scheduled on 1:00 A.M. Daily.The problem is this job is running but sometime it is not running.Can any body suggest what may be the problemThanksNeelesh" |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-08-27 : 11:53:49
|
| We need more imformation. Look in the Job history :EM , management, SQL server agent, Jobs. Right click your job, click on View job History. Check the show step details. this should give you more information on the specific types of errors being experienced.HTH |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-08-27 : 13:07:16
|
| Have you looked to see if the schedule is enabled?If someone runs it a single time only the schedule gets disabled afterwards.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
SQL Server Job Schedule