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 2005 Forums
 Other SQL Server Topics (2005)
 SQL Scheduler Job problem

Author  Topic 

Vasant Ghooli
Starting Member

1 Post

Posted - 2008-05-29 : 07:58:33
We have created a Job in the SQL server Agent to execute some of the tasks which will load the data from XML to DB. These jobs will run exactly 15 days then they will get hanged. We need to restart the server to start the job again.

Could anybody give the suggestion to solve this problem.

Thanks in Advance and Regards,
Vasant Ghooli

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-29 : 13:12:40
You haven't provided enough information for us to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Go to Top of Page
   

- Advertisement -