Facillimus via ut Create an erecti Using the discere SQL Servo Agent

SQL Servo Alerts videt rotundum-the-horologium error Notification

SQL Servo augue dui sinit datorum notitia cum insolita rerum administratione occurrunt. Hoc mechanism dat XXIV-hora potens erecti magna database perficientur in a XXIV-hora sine staffing res centrum.

Definiens enim opus est Generalis et erecti

Ad quorum avidae, opus basic notitia certa comprehendo:

GRADATUS SQL Servo erecti Setup

SQL Servo MMV ad praecepta atque succrescens.

  1. SQL Servo Aperi Management ad coniungere Studio et server basis datorum invenire ubi vos volo creo an intenti.
  2. SQL Servo in folder Expand agente semel per clicking a "+" folder icon ut ad sinistram.
  3. Vox-click in folder Alerts eligere nova et erecti a pop-sursum menu.
  4. Typus a cognominatione quia erecti sunt in nomine text arca archa.
  5. Eligere genus erecti a gutta-down menu. SQL Servo CPU perficiendi condiciones sunt electiones tuum sicut onus orbis tractus et liber: SQL Servo certe tam exitiale quam errores, erroribus, Syntax hardware exitibus et instrumental Fenestra Management (WMI) events.
  6. Provide intentus aliquo singula Utilia rogatus a SQL Servo illud includitur in eventu famam ut propria summis montibus et RUBIDIUM perficientur conditio.
  7. Click in icon responsione nova erecti fenestra in a page Selecta pane.
  8. Si vis agens officium exequi SQL Servo in erectissimus cum occurs conjunctionem preme: Judicium officium et reprehendo ex officium eligere occumbo-down menu.
  9. Si vis certiorem database cum operators erecti occurs conjunctionem preme Notify operators reprehendo arca archa tunc lego notitia in genera et operators a malesuada euismod.
  1. Click OK creare erectissimus omnino fuerat.

Using Transact Alerts addere-SQL

Inde SQL Server MMVIII, vos can adde etiam fuligo, per SQL Transact. Uti Microsoft is syntax:

sp_add_alert [= @name] [[= @message_id] message_id] [[= @severity] districtionis] [[= @enabled] enabled] [[= @delay_between_responses] delay_between_responses] [[= @notification_message] ' notification_message '] [[= @include_event_description_in] include_event_description_in] [[= @database_name]' database '] [[= @event_description_keyword]' event_description_keyword_pattern '] [, {[= @job_id] job_id | [@job_name =] 'job_name,}] [[= @raise_snmp_trap] raise_snmp_trap] [[= @performance_condition]' performance_condition '] [[= @category_name]' genus '] [[= @wmi_namespace]' wmi_namespace '] [[= @wmi_query]' wmi_query ']