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 |
|
roykauf
Starting Member
36 Posts |
 Posted - 2008-08-25 : 09:35:50
|
| I made a new SQL Job. somehow the job works for few times and then stop working. no the Result pane it shows the last succesful result which is few hours ago, while the job should run every 10 minutes.if i click on the Job history I see that all the attempts where successful but it is not working!! . on the current activity log I see a lock on that store procedure which is ivoked by the job, if I try to kill the process, it is not killed till I make restart to the server. What might be the reason for all of this and what should be the result?PLZ send me a short feedback.Roy |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-25 : 09:40:52
|
| Whats the job basically doing? |
 |
|
|
roykauf
Starting Member
36 Posts |
Posted - 2008-08-25 : 11:23:20
|
| The job is posting an alert by executing a SP.The SP selects the alerts to by mail for certain activities.The Procedure of sending mail is by calling to another SPIn the end of the process the SP update the AlertReportLog table sets the email field as sent with the appropriate AlertLogID. |
|
|
|
|
|
|
Problem with SQL Job