Sql agent jobs sitting in queue

Question

Sql agent jobs sitting in queue

Juanita

SSCertifiable

Points: 5300
More actions
February 28, 2003 at 7:24 am

#158719

HI. I noticed in EM that there are several sql agent jobs that have been out there for 3 days. These are the jobs to a particular databases maintenance plan. If I look under JOBS, it shows the status of these jobs as EXECUTING..At this point, can i cancell these processes? it appears they are all waiting to run..i'm still getting my feet wet with sql server and have never seen this.
thanks,
juanita

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

Do a refresh in EM first, just to make sure you get the latest status. Executing means they are running. Yes, you can stop the jobs, but without knowing the specifics of what they do, it's hard for anyone to forecast what the effects will be.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley

Juanita SSCertifiable Points: 5300 More actions · Answer 2

Good Morning Brian,

I did do a refresh and they are all still there. They are all the typical jobs that take place in a database maintenance plan. when i look at the next run date for each of these jobs, it lists the date that they should be running. it's as if they all got hung up on 1 thing. the first job to get held up was the tlog backup,next integrity checks and then the database backups.. it appears as if they never executed. is there a way to see if they are actually executing?

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 3

It appears there are problems in processes sqlmaint.exe. Go to server task manager --> Processes to locate sqlmain.exe and kill them. And rerun your jobs.

Which version of SQL Server and Windows you are runing?

Juanita SSCertifiable Points: 5300 More actions · Answer 4

I'm running sql server 2000 standard edition on windows nt 4.0. i wanted to mention that all my other maintenance plans have been executing fine everynight. it just appears that it is only on 2 database plans. could it be that another job was running at the same time and hung the plans up.

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 5

I have seen this issue myself and from someone else few times and really don't have ideas why process sqlmain.exe hangs.

Try to recreate separtate maintenance plans.

Juanita SSCertifiable Points: 5300 More actions · Answer 6

HI. Well i tried stopping and starting the agent and when i tried to start the agent, it would say it was already started. so i stopped the agent thru the services manager and tried to start it there and it just hung and just kept saying 'starting agent'. so i closed the agent thru the services on the nt box and tried again thru EM and no luck. so i just rebooted sql server and that fixed my agent problem. on the issue of seperate maintenance plans, i already have each database in its own plan. so i'm going to keep my fingers crossed that it doesn't start acting up again.

thank you again for all help

juanita

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 7

You really don't have to restart server and the reason Agent service can't be stoped and started is because the process sqlmain.exe hung. Go to the task manager to kill all sqlmaint.exe processes and you will be able to restart the Agent server from EM or service manager.