{"id":23314,"date":"2023-10-12T14:52:52","date_gmt":"2023-10-12T12:52:52","guid":{"rendered":"https:\/\/alarm-it-factory.de\/?page_id=23314"},"modified":"2025-06-17T10:37:16","modified_gmt":"2025-06-17T08:37:16","slug":"agent-for-microsoft-sql-databases","status":"publish","type":"page","link":"https:\/\/alarm-it-factory.de\/en\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/","title":{"rendered":"Agent for Microsoft SQL databases"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><div class=\"vc_row wpb_row vc_row-fluid vc_column-gap-24 vc-row-45994\" >\n\t<div class=\"container et-clearfix\">\n\t\t<div class=\"wpb_column vc_column_container vc_col-sm-6 vc_hidden-sm vc_hidden-xs text-align-none vc-column-766787\" >\n\t<div class=\"vc_column-inner vc_custom_1636714960539\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<span class=\"et-gap et-clearfix et-gap-690982\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<h2><span style=\"font-size: 25px; line-height: 35px; font-weight: 400;\">Interface between<br \/>\nMicrosoft SQL databases and Alarm Control Center<\/span><\/h2>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-853965\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<p>The ACC's <strong>Agent for Microsoft SQL databases<\/strong> (MS SQL) creates messages based on entries in configurable SQL tables. These messages are then <a href=\"https:\/\/alarm-it-factory.de\/en\/alarm-control-center\/\">Alarm Control Center<\/a> (ACC) to the responsible persons. The agent supports all current <a href=\"https:\/\/de.wikipedia.org\/wiki\/Microsoft_SQL_Server\">Microsoft SQL Server<\/a>.<\/p>\n<p>The following systems can be connected, among others:<\/p>\n<ul>\n<li>zenon8.00<\/li>\n<li>Wonderware ArchestrA<\/li>\n<\/ul>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-569152 hide1024\"><\/span>\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div><div class=\"wpb_column vc_column_container vc_col-sm-6 vc_hidden-sm vc_hidden-xs text-align-none vc-column-902540\" >\n\t<div class=\"vc_column-inner vc_custom_1636714967914\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_center\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/Agenten.svg\" class=\"vc_single_image-img attachment-medium\" alt=\"Agent for Microsoft SQL databases\" title=\"ACC Agent, icon\" data-responsive-images=\"false\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div>\t<\/div>\n\t\t<\/div><div class=\"kswr-row-element-back kswr-vc-ctn-element\" data-classes=\"kswr_pnone kswr_mnone kswr_bnone\" ><\/div><div class=\"vc_row wpb_row vc_row-fluid vc_column-gap-24 vc-row-45994\" >\n\t<div class=\"container et-clearfix\">\n\t\t<div class=\"wpb_column vc_column_container vc_col-sm-12 vc_hidden-lg vc_hidden-md text-align-none vc-column-183235\" >\n\t<div class=\"vc_column-inner vc_custom_1636715007835\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_center\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/Agenten.svg\" class=\"vc_single_image-img attachment-medium\" alt=\"Agent for Microsoft SQL databases\" title=\"ACC Agent, icon\" data-responsive-images=\"false\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n<span class=\"et-gap et-clearfix et-gap-365743\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<h2><span style=\"font-size: 18px;\">Interface between Microsoft SQL databases and Alarm Control Center<\/span><\/h2>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-138704\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<p>The ACC's <strong>Agent for Microsoft SQL databases<\/strong> (MS SQL) creates messages based on entries in configurable SQL tables. These messages are then <a href=\"https:\/\/alarm-it-factory.de\/en\/alarm-control-center\/\">Alarm Control Center<\/a> (ACC) to the responsible persons. The agent supports all current <a href=\"https:\/\/de.wikipedia.org\/wiki\/Microsoft_SQL_Server\">Microsoft SQL Server<\/a>.<\/p>\n<p>The following systems can be connected, among others:<\/p>\n<ul>\n<li>zenon8.00<\/li>\n<li>Wonderware ArchestrA<\/li>\n<\/ul>\n\t<\/div>\n<\/div>\n\n\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div>\t<\/div>\n\t\t<\/div><div class=\"kswr-row-element-back kswr-vc-ctn-element\" data-classes=\"kswr_pnone kswr_mnone kswr_bnone\" ><\/div><div class=\"vc_row wpb_row vc_row-fluid vc_custom_1636715015891 vc_row-has-fill vc_column-gap-24 vc-row-304355\" >\n\t<div class=\"container et-clearfix\">\n\t\t<div class=\"wpb_column vc_column_container vc_col-sm-6 vc_hidden-sm vc_hidden-xs text-align-none vc-column-833803\" >\n\t<div class=\"vc_column-inner vc_custom_1636715024372\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<span class=\"et-gap et-clearfix et-gap-694211 hide1024\"><\/span>\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_center  vc_custom_1697113068027\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"255\" src=\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2023\/10\/Datenbank_Tabelle-V2-300x255.png\" class=\"vc_single_image-img attachment-medium\" alt=\"Agent for Microsoft SQL databases\" title=\"Database_Table V2\" data-responsive-images=\"false\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div><div class=\"wpb_column vc_column_container vc_col-sm-6 vc_hidden-sm vc_hidden-xs text-align-none vc-column-384363\" >\n\t<div class=\"vc_column-inner vc_custom_1636715032229\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<span class=\"et-gap et-clearfix et-gap-626828\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<h3><span style=\"font-size: 18pt;\">Communication via the SQL database<\/span><\/h3>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-138704\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<p>When a new entry is added to the configurable SQL table, the MS SQL agent is informed. The agent then generates a message for the <a href=\"https:\/\/alarm-it-factory.de\/en\/alarm-control-center\/\">Alarm Control Center<\/a> and the participants are alerted.<\/p>\n<p>If the message is processed or acknowledged, the agent can trigger \u201cMessage sent\u201d and the corresponding column in the SQL table is updated.<\/p>\n<p>The MS SQL agent documents all events surrounding a message, such as alarms and acknowledgments by participants, in a configurable SQL table.<\/p>\n\t<\/div>\n<\/div>\n\n\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div>\t<\/div>\n\t\t<\/div><div class=\"kswr-row-element-back kswr-vc-ctn-element\" data-classes=\"kswr_pnone kswr_mnone kswr_bnone\" ><\/div><div class=\"vc_row wpb_row vc_row-fluid vc_custom_1636715015891 vc_row-has-fill vc_column-gap-24 vc-row-304355\" >\n\t<div class=\"container et-clearfix\">\n\t\t<div class=\"wpb_column vc_column_container vc_col-sm-12 vc_hidden-lg vc_hidden-md text-align-none vc-column-992073\" >\n\t<div class=\"vc_column-inner vc_custom_1636715059888\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_center\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"255\" src=\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2023\/10\/Datenbank_Tabelle-V2-300x255.png\" class=\"vc_single_image-img attachment-medium\" alt=\"Agent for Microsoft SQL databases\" title=\"Database_Table V2\" data-responsive-images=\"false\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n<span class=\"et-gap et-clearfix et-gap-810010 hide1024\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<h3><span style=\"font-size: 18pt;\">Communication via the SQL database<\/span><\/h3>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-138704\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<p>When a new entry is added to the configurable SQL table, the MS SQL agent is informed. The agent then generates a message for the <a href=\"https:\/\/alarm-it-factory.de\/en\/alarm-control-center\/\">Alarm Control Center<\/a> and the participants are alerted.<\/p>\n<p>If the message is processed or acknowledged, the agent can trigger \u201cMessage sent\u201d and the corresponding column in the SQL table is updated.<\/p>\n<p>The MS SQL agent documents all events surrounding a message, such as alarms and acknowledgments by participants, in a configurable SQL table.<\/p>\n\t<\/div>\n<\/div>\n\n\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div>\t<\/div>\n\t\t<\/div><div class=\"kswr-row-element-back kswr-vc-ctn-element\" data-classes=\"kswr_pnone kswr_mnone kswr_bnone\" ><\/div><div class=\"vc_row wpb_row vc_row-fluid vc_column-gap-24 vc-row-172995\" >\n\t<div class=\"container et-clearfix\">\n\t\t<div class=\"wpb_column vc_column_container vc_col-sm-6 vc_hidden-sm vc_hidden-xs text-align-none vc-column-167479\" >\n\t<div class=\"vc_column-inner vc_custom_1636715089512\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<span class=\"et-gap et-clearfix et-gap-120001\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<h3><span style=\"font-size: 18pt;\">Automatic database cleanup<\/span><\/h3>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-138704\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<p>If the number of entries in the table exceeds a specified number, the database is automatically cleaned up.<\/p>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-875009\"><\/span>\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div><div class=\"wpb_column vc_column_container vc_col-sm-6 vc_hidden-sm vc_hidden-xs text-align-none vc-column-433419\" >\n\t<div class=\"vc_column-inner vc_custom_1636715084145\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_center\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2023\/10\/Delete_blau.svg\" class=\"vc_single_image-img attachment-medium\" alt=\"Agent for Microsoft SQL databases\" title=\"Delete_blue\" data-responsive-images=\"false\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div>\t<\/div>\n\t\t<\/div><div class=\"kswr-row-element-back kswr-vc-ctn-element\" data-classes=\"kswr_pnone kswr_mnone kswr_bnone\" ><\/div><div class=\"vc_row wpb_row vc_row-fluid vc_column-gap-24 vc-row-172995\" >\n\t<div class=\"container et-clearfix\">\n\t\t<div class=\"wpb_column vc_column_container vc_col-sm-12 vc_hidden-lg vc_hidden-md text-align-none vc-column-358784\" >\n\t<div class=\"vc_column-inner vc_custom_1636715116511\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_center\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2023\/10\/Delete_blau.svg\" class=\"vc_single_image-img attachment-medium\" alt=\"Agent for Microsoft SQL databases\" title=\"Delete_blue\" data-responsive-images=\"false\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n<span class=\"et-gap et-clearfix et-gap-503120\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<h3><span style=\"font-size: 18pt;\">Automatic database cleanup<\/span><\/h3>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-138704\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<p>If the number of entries in the table exceeds a specified number, the database is automatically cleaned up.<\/p>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-875009\"><\/span>\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div>\t<\/div>\n\t\t<\/div><div class=\"kswr-row-element-back kswr-vc-ctn-element\" data-classes=\"kswr_pnone kswr_mnone kswr_bnone\" ><\/div><div class=\"vc_row wpb_row vc_row-fluid vc_custom_1636715130588 vc_row-has-fill vc_column-gap-24 vc-row-841710\" >\n\t<div class=\"container et-clearfix\">\n\t\t<div class=\"wpb_column vc_column_container vc_col-sm-6 vc_hidden-sm vc_hidden-xs text-align-none vc-column-192891\" >\n\t<div class=\"vc_column-inner vc_custom_1636715139472\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<span class=\"et-gap et-clearfix et-gap-585363\"><\/span>\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_left\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"229\" src=\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/Ausfallsicherheit-2-300x229.png\" class=\"vc_single_image-img attachment-medium\" alt=\"Agent for Microsoft SQL databases\" title=\"Reliability\" data-responsive-images=\"false\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n<span class=\"et-gap et-clearfix et-gap-569152 hide1024\"><\/span>\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div><div class=\"wpb_column vc_column_container vc_col-sm-6 vc_hidden-sm vc_hidden-xs text-align-none vc-column-130222\" >\n\t<div class=\"vc_column-inner vc_custom_1636715147154\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<h3><span style=\"font-size: 18pt;\">Increased reliability through the monitoring option<\/span><\/h3>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-410644\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<p>Increased reliability is ensured by the <a href=\"https:\/\/alarm-it-factory.de\/en\/alarm-control-center\/components\/options\/option-monitoring\/\">\u00a0<strong>Monitoring option<\/strong><\/a>. This option monitors all functions of the Alarm Control Center and also provides the following functionalities for the MS SQL agent:<\/p>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-352406\"><\/span><ul id=\"et-icon-list-981291\" class=\"et-icon-list medium full\"><li><div class=\"icon-wrap\"><div class=\"icon medium\"><span class=\"medium fas fa-angle-right\"><\/span><\/div><\/div><div><strong>Control system availability: <\/strong> It is tested whether the control system is functional and correctly connected to the ACC.<\/div><\/li><li><div class=\"icon-wrap\"><div class=\"icon medium\"><span class=\"medium fas fa-angle-right\"><\/span><\/div><\/div><div><strong>Message volume: <\/strong> It tests whether the number of messages per second in the agent&#039;s queue exceeds a configured limit.<\/div><\/li><\/ul>\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div>\t<\/div>\n\t\t<\/div><div class=\"kswr-row-element-back kswr-vc-ctn-element\" data-classes=\"kswr_pnone kswr_mnone kswr_bnone\" ><\/div><div class=\"vc_row wpb_row vc_row-fluid vc_custom_1636715130588 vc_row-has-fill vc_column-gap-24 vc-row-841710\" >\n\t<div class=\"container et-clearfix\">\n\t\t<div class=\"wpb_column vc_column_container vc_col-sm-12 vc_hidden-lg vc_hidden-md text-align-none vc-column-286330\" >\n\t<div class=\"vc_column-inner vc_custom_1636715166617\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_center\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"229\" src=\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/Ausfallsicherheit-2-300x229.png\" class=\"vc_single_image-img attachment-medium\" alt=\"Agent for Microsoft SQL databases\" title=\"Reliability\" data-responsive-images=\"false\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n<span class=\"et-gap et-clearfix et-gap-993923 hide1024\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<h3>Increased reliability through the monitoring option<\/h3>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-410644\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<p>Increased reliability is ensured by the <a href=\"https:\/\/alarm-it-factory.de\/en\/alarm-control-center\/components\/options\/option-monitoring\/\">\u00a0<strong>Monitoring option<\/strong><\/a>. This option monitors all functions of the Alarm Control Center and also provides the following functionalities for the MS SQL agent:<\/p>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-352406\"><\/span><ul id=\"et-icon-list-853066\" class=\"et-icon-list medium full\"><li><div class=\"icon-wrap\"><div class=\"icon medium\"><span class=\"medium fas fa-angle-right\"><\/span><\/div><\/div><div><strong>Control system availability: <\/strong> It is tested whether the control system is functional and correctly connected to the ACC.<\/div><\/li><li><div class=\"icon-wrap\"><div class=\"icon medium\"><span class=\"medium fas fa-angle-right\"><\/span><\/div><\/div><div><strong>Message volume: <\/strong> It tests whether the number of messages per second in the agent&#039;s queue exceeds a configured limit.<\/div><\/li><\/ul>\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div>\t<\/div>\n\t\t<\/div><div class=\"kswr-row-element-back kswr-vc-ctn-element\" data-classes=\"kswr_pnone kswr_mnone kswr_bnone\" ><\/div><div data-curtain-gradient=\"true\" data-curtain-gradient-position=\"right\" class=\"vc_row wpb_row vc_row-fluid call-to-action vc_custom_1602852246494 vc_row-has-fill vc_row-o-equal-height vc_row-flex vc-fixed-bg vc-row-193339\" >\n\t<div class=\"container et-clearfix\">\n\t\t<div class=\"call-to-action-links wpb_column vc_column_container vc_col-sm-2\/5 vc_col-lg-6 vc_col-md-6 vc_col-xs-12 text-align-none vc-column-343670\" >\n\t<div class=\"vc_column-inner\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div><div class=\"call-to-action-rechts wpb_animate_when_almost_visible wpb_right-to-left right-to-left wpb_column vc_column_container vc_col-sm-3\/5 vc_col-lg-6 vc_col-md-6 vc_col-xs-12 text-align-none vc-column-943404\" data-animation-delay=\"600\" >\n\t<div class=\"vc_column-inner\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<span class=\"et-gap et-clearfix et-gap-464629\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<h4><span style=\"color: #ffffff; font-size: 25px; line-heigt: 35px; font-weight: 400;\">Would you like to learn more about our agent for Microsoft SQL databases?<\/span><\/h4>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-742520\"><\/span>\n<div class=\"wpb_text_column wpb_content_element\"  data-animation-delay=\"0\">\n\t<div class=\"wpb_wrapper\">\n\t\t<p><span style=\"color: #000000;\"><span class=\"et-font-size\" data-fontsize=\"24px\" data-lineheight=\"32px\">Contact us. We are happy to help.<\/span><\/span><\/p>\n\t<\/div>\n<\/div>\n\n<span class=\"et-gap et-clearfix et-gap-822385\"><\/span><a id=\"et-button-121462\" class=\"et-button icon-position-right modal-false large hover-fill click-none has-icon\" target=\"_self\" href=\"\/en\/contact\/\" data-animation-delay=\"0\" data-parallax=\"false\" data-move=\"false\" data-coordinatex=\"0\" data-coordinatey=\"0\" data-speed=\"10\"><span class=\"hover\"><\/span><span class=\"regular\"><\/span><span class=\"text\">to the contact form<\/span><span class=\"icon ien ien-earrow-3\"><\/span><\/a><span class=\"et-gap et-clearfix et-gap-348193\"><\/span>\t\t<\/div>\n\t\t\t<\/div>\n<\/div><div class=\"kswr-column-settings\" data-minheight=\"0px\" data-isminheight=\"off\" data-theclasses=\"kswr_pnone kswr_mnone kswr_bnone\"><\/div>\t<\/div>\n\t<div class=\"curtain-gradient\"><\/div>\t<div class=\"fixed-container\"><\/div><\/div><div class=\"kswr-row-element-back kswr-vc-ctn-element\" data-classes=\"kswr_pnone kswr_mnone kswr_bnone\" ><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>The Microsoft SQL Agent is the interface between Microsoft SQL databases and the Alarm Control Center. <\/p>","protected":false},"author":9,"featured_media":22592,"parent":19445,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-vc.php","meta":{"inline_featured_image":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-23314","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Agent f\u00fcr Microsoft SQL-Datenbanken - Alarm IT Factory<\/title>\n<meta name=\"description\" content=\"Mit dem Microsoft SQL-Agent als Schnittstelle k\u00f6nnen Microsoft SQL-Datenbanken an das Alarm Control Center (ACC) angebunden werden.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/alarm-it-factory.de\/en\/alarm-control-center\/components\/agents\/agent-for-microsoft-sql-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Schnittstelle zwischen Microsoft SQL-Datenbanken und Alarm Control Center\" \/>\n<meta property=\"og:description\" content=\"Mit dem Microsoft SQL-Agent als Schnittstelle k\u00f6nnen Microsoft SQL-Datenbanken an das Alarm Control Center (ACC) angebunden werden.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/alarm-it-factory.de\/en\/alarm-control-center\/components\/agents\/agent-for-microsoft-sql-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"Alarm IT Factory\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-17T08:37:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/11\/Alarm-it-factory-die-agenten.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"380\" \/>\n\t<meta property=\"og:image:height\" content=\"380\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Schnittstelle zwischen Microsoft SQL-Datenbanken und Alarm Control Center\" \/>\n<meta name=\"twitter:description\" content=\"Mit dem Microsoft SQL-Agent als Schnittstelle k\u00f6nnen Microsoft SQL-Datenbanken an das Alarm Control Center (ACC) angebunden werden.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/11\/Alarm-it-factory-die-agenten.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/\",\"url\":\"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/\",\"name\":\"Agent f\u00fcr Microsoft SQL-Datenbanken - Alarm IT Factory\",\"isPartOf\":{\"@id\":\"https:\/\/alarm-it-factory.de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/Agenten.svg\",\"datePublished\":\"2023-10-12T12:52:52+00:00\",\"dateModified\":\"2025-06-17T08:37:16+00:00\",\"description\":\"Mit dem Microsoft SQL-Agent als Schnittstelle k\u00f6nnen Microsoft SQL-Datenbanken an das Alarm Control Center (ACC) angebunden werden.\",\"breadcrumb\":{\"@id\":\"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/#primaryimage\",\"url\":\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/Agenten.svg\",\"contentUrl\":\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/Agenten.svg\",\"caption\":\"ACC Agent, icon\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\/\/alarm-it-factory.de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Das Alarm Control Center\",\"item\":\"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Die Komponenten\",\"item\":\"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Die Agenten\",\"item\":\"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Agent f\u00fcr Microsoft SQL-Datenbanken\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/alarm-it-factory.de\/#website\",\"url\":\"https:\/\/alarm-it-factory.de\/\",\"name\":\"Alarm IT Factory\",\"description\":\"Alarmierungssoftware\",\"publisher\":{\"@id\":\"https:\/\/alarm-it-factory.de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/alarm-it-factory.de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/alarm-it-factory.de\/#organization\",\"name\":\"Alarm IT Factory GmbH\",\"url\":\"https:\/\/alarm-it-factory.de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/alarm-it-factory.de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/AIF_logo.png\",\"contentUrl\":\"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/AIF_logo.png\",\"width\":312,\"height\":52,\"caption\":\"Alarm IT Factory GmbH\"},\"image\":{\"@id\":\"https:\/\/alarm-it-factory.de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Agent for Microsoft SQL databases - Alarm IT Factory","description":"Using the Microsoft SQL Agent as an interface, Microsoft SQL databases can be connected to the Alarm Control Center (ACC).","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/alarm-it-factory.de\/en\/alarm-control-center\/components\/agents\/agent-for-microsoft-sql-databases\/","og_locale":"en_US","og_type":"article","og_title":"Schnittstelle zwischen Microsoft SQL-Datenbanken und Alarm Control Center","og_description":"Mit dem Microsoft SQL-Agent als Schnittstelle k\u00f6nnen Microsoft SQL-Datenbanken an das Alarm Control Center (ACC) angebunden werden.","og_url":"https:\/\/alarm-it-factory.de\/en\/alarm-control-center\/components\/agents\/agent-for-microsoft-sql-databases\/","og_site_name":"Alarm IT Factory","article_modified_time":"2025-06-17T08:37:16+00:00","og_image":[{"width":380,"height":380,"url":"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/11\/Alarm-it-factory-die-agenten.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_title":"Schnittstelle zwischen Microsoft SQL-Datenbanken und Alarm Control Center","twitter_description":"Mit dem Microsoft SQL-Agent als Schnittstelle k\u00f6nnen Microsoft SQL-Datenbanken an das Alarm Control Center (ACC) angebunden werden.","twitter_image":"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/11\/Alarm-it-factory-die-agenten.jpg","twitter_misc":{"Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/","url":"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/","name":"Agent for Microsoft SQL databases - Alarm IT Factory","isPartOf":{"@id":"https:\/\/alarm-it-factory.de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/#primaryimage"},"image":{"@id":"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/#primaryimage"},"thumbnailUrl":"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/Agenten.svg","datePublished":"2023-10-12T12:52:52+00:00","dateModified":"2025-06-17T08:37:16+00:00","description":"Using the Microsoft SQL Agent as an interface, Microsoft SQL databases can be connected to the Alarm Control Center (ACC).","breadcrumb":{"@id":"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/#primaryimage","url":"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/Agenten.svg","contentUrl":"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/Agenten.svg","caption":"ACC Agent, icon"},{"@type":"BreadcrumbList","@id":"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/agent-fuer-microsoft-sql-datenbanken\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/alarm-it-factory.de\/"},{"@type":"ListItem","position":2,"name":"Das Alarm Control Center","item":"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/"},{"@type":"ListItem","position":3,"name":"Die Komponenten","item":"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/"},{"@type":"ListItem","position":4,"name":"Die Agenten","item":"https:\/\/alarm-it-factory.de\/alarmcontrolcenter\/komponenten\/agenten\/"},{"@type":"ListItem","position":5,"name":"Agent f\u00fcr Microsoft SQL-Datenbanken"}]},{"@type":"WebSite","@id":"https:\/\/alarm-it-factory.de\/#website","url":"https:\/\/alarm-it-factory.de\/","name":"Alarm IT Factory","description":"Alerting software","publisher":{"@id":"https:\/\/alarm-it-factory.de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/alarm-it-factory.de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/alarm-it-factory.de\/#organization","name":"Alarm IT Factory GmbH","url":"https:\/\/alarm-it-factory.de\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/alarm-it-factory.de\/#\/schema\/logo\/image\/","url":"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/AIF_logo.png","contentUrl":"https:\/\/alarm-it-factory.de\/wp-content\/uploads\/2020\/09\/AIF_logo.png","width":312,"height":52,"caption":"Alarm IT Factory GmbH"},"image":{"@id":"https:\/\/alarm-it-factory.de\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/alarm-it-factory.de\/en\/wp-json\/wp\/v2\/pages\/23314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alarm-it-factory.de\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/alarm-it-factory.de\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/alarm-it-factory.de\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/alarm-it-factory.de\/en\/wp-json\/wp\/v2\/comments?post=23314"}],"version-history":[{"count":10,"href":"https:\/\/alarm-it-factory.de\/en\/wp-json\/wp\/v2\/pages\/23314\/revisions"}],"predecessor-version":[{"id":24645,"href":"https:\/\/alarm-it-factory.de\/en\/wp-json\/wp\/v2\/pages\/23314\/revisions\/24645"}],"up":[{"embeddable":true,"href":"https:\/\/alarm-it-factory.de\/en\/wp-json\/wp\/v2\/pages\/19445"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/alarm-it-factory.de\/en\/wp-json\/wp\/v2\/media\/22592"}],"wp:attachment":[{"href":"https:\/\/alarm-it-factory.de\/en\/wp-json\/wp\/v2\/media?parent=23314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alarm-it-factory.de\/en\/wp-json\/wp\/v2\/categories?post=23314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alarm-it-factory.de\/en\/wp-json\/wp\/v2\/tags?post=23314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}