Is this all a bit confusing? Yes. However, it??™s critical to understand if you??™re going to
use SQL Agent as your backup scheduling process. The SQL Server 2005 proxy system is
immensely more complex and flexible than previous versions. With multiple levels of
abstraction, you??™re not only in control of how any given user interacts with the operating
system, but you??™re also able to keep this information hidden from standard users. In a
large environment, the proxy system can be a significant boon to security.
Alerts
SQL Agent has always had the ability to fire alerts given various conditions. This hasn??™t
changed under SQL Server 2005. You can create an alert based on a SQL Server error message,
a user-defined error message (the message ID must be greater than 50,000), a SQL
Server performance event, or a Windows Management Instrumentation (WMI) event.
Of course, you can also set an alert notification for any specific job step, which is
what we??™re most interested in. You can have it notify an operator, and this is where things
change from previous versions. SQL Agent still offers the same three notification methods:
e-mail, pager, and network messages via the net send command.
Pages:
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249