| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2008-05-20 : 04:18:39
|
| Hey i've noticed this last few days that some of my jobs are not stopping and are running for hours when they normally only take a few seconds or minutes. Why do you think this is happening. There has been no problem with the server. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-20 : 05:57:08
|
What does the logs tell you?Windows logs, SQL Server logs.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2008-05-20 : 06:47:15
|
| See the job never stops it runs indefinitly so i have to stop it my self and then you don't get a log by doing that so i can't tell whats going on.. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-20 : 07:49:25
|
Which step in job is running forever?Which SP or code is runnning forever?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-20 : 21:35:09
|
| You can trace it in profiler. |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2008-05-23 : 04:14:11
|
| When i ran a trace on it its just keeps running dbo.sp_sqlagent_get_perf_counters over and over again... from the msdb database |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-23 : 05:13:20
|
What does the code look like in that jobstep?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2008-05-23 : 08:54:48
|
| To test why the job was not running i set up a very simple DTS package one with e-mail and one without e-mailThe one without the email work fine when scheduled The one with the email work hang when scheduled to runAll i have is a connection toa DB then a simple select query and then send email task when complete. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-05-23 : 13:14:57
|
| I had that once or twice in the past year. You'll see the process (I used sp_who2) as executing email but utilizing no resources. You'll need to stop and restart the SQL Agent to get this working. Our SQL server experienced a disconnect with our exchange server and the connection had been dropped. Restarting the agent corrected our problem.Terry |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2008-05-26 : 04:16:43
|
| I Stop the agent and then restarted it again, and am still getting the same problem. I done this about a week ago also. All the jops with an email task failed this weekend again. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-26 : 04:23:06
|
Do you have email correctly set up?Do you have an account?Do the password match user name?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-26 : 18:42:04
|
| Which type of mail used? Was mail server running? |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2008-05-27 : 04:14:15
|
| Do you have email correctly set up? Yes it has been working correctly this last few years also if i run the DTS package as normal i get the email.Do you have an account? yesDo the password match user name? yes...Am using outlook it only stop working about 3 weeks ago.. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-05-27 : 15:34:54
|
| Can you send a test email from SQL server? This may show you an actual error message if it fails, which should help in debugging the situation. Are you positive that nothing related to this is in your SQL logs? Did you look in event viewer on the SQL server machine to see if anything is logging there?Terry |
|
|
|
|
sql jobs running indefinitely