Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swatib
Posting Yak Master
173 Posts |
 Posted - 2007-01-10 : 23:23:31
|
I've a sql job which is running twice in a day at 3 PM and 9PM.It runs successful for 3 PM but stick up that is continuously running for 9PM time. I don't understand what this is happening. If I cancel the stucked job and run manually then it runs fine. There is no other job that runs at 9PM. Please guide me why this is happening and provide the solution for the same.ThanksNjoy Life  |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2007-01-10 : 23:33:46
|
| what does the job do?plz specify each step,what do u mean by stuck?, it just wont do anything? if yes what does it write to event logs?its me monty |
 |
|
|
swatib
Posting Yak Master
173 Posts |
Posted - 2007-01-11 : 00:39:10
|
quote:
Originally posted by monty
plz specify each step,what do u mean by stuck?, it just wont do anything? if yes what does it write to event logs?
The job executes one VB application exe. The VB application has the code for writing log when the job fails. But it is not showing any error occured. But I've seen one entry for that database (where the job resides) in Current Activity -> Locks/Process ID in Enterprise Magr.Njoy Life |
|
|
|
|
|
|
Schduled sql job sometimes stuck up