Solved

job run status kept excuting forever

Posted on 2009-05-12
4
313 Views
Last Modified: 2012-05-06
Expert,

I have on DTS job it run once a day in 5 am, I checked it during day time 2pm, the status is excuting but the job history for that day is empty. The status on excuting for 2 days then started to run. I checked disk space, it is no space problem.  All backup is not in 5 am. I don't know what caused the problems.

Can you help?
0
Comment
Question by:yrcdba7
  • 2
4 Comments
 

Author Comment

by:yrcdba7
ID: 24369640

From SQL Server agent, go to jobs, go to last run status, the job excuting more than 24 hours, regular run time is 49 second. no job history message. what cause the job last run status (start date) - excuting hanging there?
pl help?
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 24369651
check in you sql agent - properties -> how many records to keep - maybe you need to make this number bigger

see more:
http://www.mssqltips.com/tip.asp?tip=1269
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 24371009
I have seen this happen when you have two different jobs (not steps) scheduled at the same time.
0
 

Author Comment

by:yrcdba7
ID: 25518855
Thank you for the help.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
email the result out from a T-SQL queries 29 64
Permissions on Database 11 37
email about the whoisactive result 7 27
SQL VIEW 7 23
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now