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
 SQL Server Administration (2005)
 sql server job issue

Author  Topic 

boreddy
Posting Yak Master

172 Posts

Posted - 2010-09-02 : 13:38:10

in my server we have one sql job, which runs every day 3 PM
we schedule this from last four days. last three days job ran success full. today also job started at 3 am and it completed many steps but
in last before step it is taking long time (more than 2 hrs)
i stopped the job and tried to re run from where i stopped, but again it is taking more time

i want the reason why it is happening
please suggest me quickly

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-02 : 14:59:02
Check blocking. Run SQL Profiler.

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

Subscribe to my blog
Go to Top of Page
   

- Advertisement -