Also, you
needed to have a MAPI-based e-mail client installed on the server. Also, if that client
was anything other than Microsoft Outlook (Outlook Express didn??™t count), it probably
had issues.
SQL Mail is still available (in SQL Server Management Studio, it??™s under Management
?¤ Legacy??”how fitting), but the primary mail-notification system is Database
Mail, which is SMTP-based and completely stateless. It doesn??™t need an SMTP server to
be installed on SQL Server, and it needs only one (or more, since it supports a fail-safe
address) IP address to send the message. I had been using an extended stored procedure
SMTP-based mailer for the SQL Server 2000 databases I worked with, so having Database
Mail included in the product is invaluable.
USING A MASTER JOB SERVER
SQL Agent has long had the ability to use a single server to control all the jobs on your network. SQL
Agent in SQL Server 2005 is no exception. I??™ve used this functionality many times. It can be a real timesaver,
and it avoids the need to purchase a third-party schedule-management package. Once target
servers are configured to use a master job server, they frequently check that master server for new
jobs to download.
Pages:
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251