Solved

job run status kept excuting forever

Posted on 2009-05-12
4
314 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Generate Scripts Fails 5 36
T-SQL: Do I need CLUSTERED here? 13 44
SQL Improvement  ( Speed) 14 28
CPU high usage when update statistics 2 30
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

778 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