job run status kept excuting forever


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?
Who is Participating?
Anthony PerkinsConnect With a Mentor Commented:
I have seen this happen when you have two different jobs (not steps) scheduled at the same time.
yrcdba7Author Commented:

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?
Eugene ZCommented:
check in you sql agent - properties -> how many records to keep - maybe you need to make this number bigger

see more:
yrcdba7Author Commented:
Thank you for the help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.