x

SQL AGENT JOB

SQL Server Scheduled Job - says its running with no errors but doing nothing.... Average completion job time is 3 hours ..but its showing running...Tell me Issue.. alt text

error-job.jpg (8.9 kB)
more ▼

asked Jul 10, 2015 at 12:26 PM in Default

avatar image

rakeshsingh1983
61 1 6

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

You could see if it's being blocked by something (unlikely but you want to make sure). Run sp_who2 and see if its process is being blocked by another (in the BlkBy column). You could check how hard the machine is working. It might just be working hard and therefore slow. You could look at what the job does. If it processes an input file, is the latest file much bigger than usual?

more ▼

answered Jul 10, 2015 at 12:44 PM

avatar image

David Wimbush
10.7k 30 34 43

(comments are locked)
10|1200 characters needed characters left

How long has it been running (ie. is it over-running)? How do you know it's doing nothing? Perhaps it's taking longer than usual because the server is working harder than usual.

more ▼

answered Jul 10, 2015 at 12:29 PM

avatar image

David Wimbush
10.7k 30 34 43

its showing running more than 12 hours..still showing running..average competition time is 3 hours..

Jul 10, 2015 at 12:40 PM rakeshsingh1983
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x8

asked: Jul 10, 2015 at 12:26 PM

Seen: 56 times

Last Updated: Jul 10, 2015 at 12:44 PM

Copyright 2017 Redgate Software. Privacy Policy