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 2008 Forums
 SQL Server Administration (2008)
 Job threshold issue

Author  Topic 

binucn
Starting Member

5 Posts

Posted - 2011-04-07 : 01:49:14
Sometimes running the job causes the following error

The SQL Server Agent Job "xxxxxx" has breached the long running job error threshold of 120 minutes.


any help highly appreciated
Binu

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2011-04-07 : 19:20:20
what exactly is it doing? can you run a trace log on it? could you improve the performance of the underlying stuff?

If you don't have the passion to help people, you have no passion
Go to Top of Page
   

- Advertisement -