{"id":16661,"date":"2021-08-24T06:26:30","date_gmt":"2021-08-24T04:26:30","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/"},"modified":"2021-08-24T06:26:30","modified_gmt":"2021-08-24T04:26:30","slug":"how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/","title":{"rendered":"How to view and change SQL Server Agent properties with T-SQL queries"},"content":{"rendered":"<p>Few days ago, after a reboot, we had this warning on the Agent Error Logs on many servers:<br \/>\n<strong>Warning [396] An idle CPU condition has not been defined &#8211; OnIdle job schedules will have no effect<\/strong><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_00.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-51275 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_00.png\" alt=\"\" width=\"300\" height=\"126\" \/><\/a><\/p>\n<p>\u201cThe CPU idle definition influences how Microsoft SQL Server Agent responds to events. For example, suppose that you define the CPU idle condition as when the average CPU usage falls below 10 percent and remains at this level for 10 minutes. Then if you have defined jobs to execute whenever the server CPU reaches an idle condition, the job will start when the CPU usage falls below 10 percent and remains at that level for 10 minutes. \u201c dixit Microsoft documentation <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/agent\/set-cpu-idle-time-and-duration-sql-server-management-studio?redirectedfrom=MSDN&amp;view=sql-server-ver15\" target=\"_blank\" rel=\"noopener\">here<\/a>.<br \/>\nTo resolve this warning, you need to go to the Agent Properties&gt;Advanced and check \u201cDefine idle CPU condition\u201d<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-51274 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_01.png\" alt=\"\" width=\"300\" height=\"167\" \/><\/a><br \/>\nThe query used to check it is:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">USE [msdb]\nGO\nEXEC msdb.dbo.sp_set_sqlagent_properties @cpu_poller_enabled=1\nGO<\/pre>\n<p>With this issue, I will also give you some helpful queries to have a look on the Agent properties.<br \/>\nThe best way to retrieve the information about the Agent properties is to use the Store Procedure: <strong>msdb.dbo.sp_get_sqlagent_properties<\/strong><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-51272 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_02.png\" alt=\"\" width=\"300\" height=\"155\" \/><\/a><br \/>\nAll information about the Agent Properties are in the Registry: <strong>HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\MSSQLServer\\SQLServerAgent<\/strong><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-51271 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_03.png\" alt=\"\" width=\"300\" height=\"207\" \/><\/a><br \/>\nYou can of course read directly the value in the Registry with the query:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">EXECUTE master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\\Microsoft\\MSSQLServer\\SQLServerAgent',N' CoreEngineMask', @cpu_poller_enabled OUTPUT, N'no_output'<\/pre>\n<p>In my case the information is on the Value Name CoreEngineMask and to have the value, you need to do a filter like this:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">IF (@cpu_poller_enabled IS NOT NULL)\nSELECT @cpu_poller_enabled = CASE WHEN (@cpu_poller_enabled &amp; 32) = 32 THEN 0 ELSE 1 END<\/pre>\n<p>To finish this article, I will give you the query that I use to put the information from the Stored Procedure in a Table to retrieve the information that need more easily:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">CREATE TABLE #sqlagent_properties\n(\nauto_start INT,\nmsx_server_name sysname NULL,\nsqlagent_type INT,\nstartup_account NVARCHAR(100) NULL,\nsqlserver_restart INT,\njobhistory_max_rows INT,\njobhistory_max_rows_per_job INT,\nerrorlog_file NVARCHAR(255) NULL,\nerrorlogging_level INT,\nerrorlog_recipient NVARCHAR(255) NULL,\nmonitor_autostart INT,\nlocal_host_server sysname NULL,\njob_shutdown_timeout INT,\ncmdexec_account VARBINARY(64) NULL,\nregular_connections INT,\nhost_login_name sysname NULL,\nhost_login_password VARBINARY(512) NULL,\nlogin_timeout INT,\nidle_cpu_percent INT,\nidle_cpu_duration INT,\noem_errorlog INT,\nsysadmin_only NVARCHAR(64) NULL,\nemail_profile NVARCHAR(64) NULL,\nemail_save_in_sent_folder INT,\ncpu_poller_enabled INT,\nalert_replace_runtime_tokens INT\n)\n\nINSERT INTO #sqlagent_properties\nEXEC msdb.dbo.sp_get_sqlagent_properties\nGO\n\nSELECT cpu_poller_enabled FROM #sqlagent_properties\n\nDROP TABLE #sqlagent_properties<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-51270 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_04.png\" alt=\"\" width=\"168\" height=\"300\" \/><\/a><\/p>\n<p>I hope this can help you when you search the Agent Properties and want to change it on your SQL Server environment<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Few days ago, after a reboot, we had this warning on the Agent Error Logs on many servers: Warning [396] An idle CPU condition has not been defined &#8211; OnIdle job schedules will have no effect \u201cThe CPU idle definition influences how Microsoft SQL Server Agent responds to events. For example, suppose that you define [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":16666,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198],"tags":[49,51,44],"type_dbi":[],"class_list":["post-16661","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","tag-microsoft","tag-sql-server","tag-troubleshooting"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to view and change SQL Server Agent properties with T-SQL queries - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to view and change SQL Server Agent properties with T-SQL queries\" \/>\n<meta property=\"og:description\" content=\"Few days ago, after a reboot, we had this warning on the Agent Error Logs on many servers: Warning [396] An idle CPU condition has not been defined &#8211; OnIdle job schedules will have no effect \u201cThe CPU idle definition influences how Microsoft SQL Server Agent responds to events. For example, suppose that you define [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-24T04:26:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_04.png\" \/>\n\t<meta property=\"og:image:width\" content=\"441\" \/>\n\t<meta property=\"og:image:height\" content=\"789\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"How to view and change SQL Server Agent properties with T-SQL queries\",\"datePublished\":\"2021-08-24T04:26:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\\\/\"},\"wordCount\":302,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SQLAgent_396_04.png\",\"keywords\":[\"Microsoft\",\"SQL Server\",\"Troubleshooting\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\\\/\",\"name\":\"How to view and change SQL Server Agent properties with T-SQL queries - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SQLAgent_396_04.png\",\"datePublished\":\"2021-08-24T04:26:30+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SQLAgent_396_04.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SQLAgent_396_04.png\",\"width\":441,\"height\":789},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to view and change SQL Server Agent properties with T-SQL queries\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to view and change SQL Server Agent properties with T-SQL queries - dbi Blog","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:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/","og_locale":"en_US","og_type":"article","og_title":"How to view and change SQL Server Agent properties with T-SQL queries","og_description":"Few days ago, after a reboot, we had this warning on the Agent Error Logs on many servers: Warning [396] An idle CPU condition has not been defined &#8211; OnIdle job schedules will have no effect \u201cThe CPU idle definition influences how Microsoft SQL Server Agent responds to events. For example, suppose that you define [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/","og_site_name":"dbi Blog","article_published_time":"2021-08-24T04:26:30+00:00","og_image":[{"width":441,"height":789,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_04.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"How to view and change SQL Server Agent properties with T-SQL queries","datePublished":"2021-08-24T04:26:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/"},"wordCount":302,"commentCount":1,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_04.png","keywords":["Microsoft","SQL Server","Troubleshooting"],"articleSection":["Database Administration &amp; Monitoring","Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/","url":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/","name":"How to view and change SQL Server Agent properties with T-SQL queries - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_04.png","datePublished":"2021-08-24T04:26:30+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_04.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SQLAgent_396_04.png","width":441,"height":789},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-view-and-change-sql-server-agent-properties-with-t-sql-queries\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to view and change SQL Server Agent properties with T-SQL queries"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16661"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16661\/revisions"}],"predecessor-version":[{"id":21571,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16661\/revisions\/21571"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/16666"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16661"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}