sql agent job hangs without any errors or warnings

Question

Post reply

sql agent job hangs without any errors or warnings

Viewing 2 posts - 1 through 3 (of 3 total)

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

shahgols SSCrazy Eights Points: 9874 More actions · Answer 1

You could do a couple of things:

1. Run Profiler and trace the job.

2. Try running the steps from SSMS (if possible).

3. Create a "log" table and insert into it after every statement. This shows you on which statement the job is stuck on.

My guess is that one of the statements in your job is being blocked.

Orlando Colamatteo SSC Guru Points: 182293 More actions · Answer 2

Are there any Script Tasks with non-trivial programs in them? Look for code that produces a message box. Sometimes developers will leave one in there by accident and it will only execute under specific circumstances which makes the hanging-behavior seem quite random.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato