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 |
|
william_lee78
Yak Posting Veteran
53 Posts |
 Posted - 2006-10-11 : 05:22:18
|
| Hi All,I have an issue happen recently on my database. A weekly SQL server job to archive some data suppose to run on Sunday night was not being executed and no one being notify about this incident until the user looking for the archive data. The job is running successfully a week before and there is no update on the server recently. Is there a way for me to check whether a job in SQL server is being executed or not being executed? There isn't any Windows Application Event log indicate the job is failed. Besides, how can I set something to notify the operator if the job is not being kick off?Thank you in advance for the help. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-11 : 05:24:51
|
| There is a NOTIFICATION tab on the job properties, where you can set several things to notify you.Peter LarssonHelsingborg, Sweden |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
To check whether a SQL Job being executed