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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Jobs Failing

Author  Topic 

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2005-06-16 : 16:11:15
Hi all
i have certain jobs running on my live server.the problem is sometimes the job fails and the very next hour it is executed sucessfully.what can be the reasons for this.The job run siccesfully the very next hour without making any change.please help on this

Regards
Nitin

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-06-16 : 16:28:11
Right click on the job, go to job history. Select the option to see job details. Highlight the detail row that failed. Post the error here.

Tara
Go to Top of Page
   

- Advertisement -