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 |
|
dhjackal
Starting Member
42 Posts |
 Posted - 2009-07-21 : 06:02:13
|
| Hello all, I'd like to be able to maintain all my transaction log backup alerts in one handy script. So far I have a stored procedure which will backup my db's transaction log if or when I pass a treshold into it e.g. 90% full. Rather than scheduling the job to run every n minutes i'd like to use the SQL Server Performance monitor alert conditions to call the script. Is this possible? I've looked at sp_add_alert but it only seems to work on specific databases. Any help appreciateddhjackal |
|
|
|
|
|
Customized alert