{"id":19165,"date":"2017-03-17T09:00:00","date_gmt":"2017-03-17T16:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=19165"},"modified":"2024-01-22T22:50:45","modified_gmt":"2024-01-23T06:50:45","slug":"sql-server-on-linux-running-jobs-with-sql-server-agent","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/","title":{"rendered":"SQL Server on Linux: Running jobs with SQL Server Agent"},"content":{"rendered":"<p>In keeping with our goal to enable SQL Server features across all platforms supported by SQL Server, Microsoft is excited to announce the preview of SQL Server Agent on Linux in SQL Server vNext Community Technology Preview (CTP) 1.4.<\/p>\n<p>SQL Server Agent is a component that executes scheduled administrative tasks, called \u201cjobs.\u201d Jobs contain one or more job steps. Each step contains its own task such as backing up a database. SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand. For example, if you want to back up all the company databases every weekday after hours, you can automate doing so by scheduling an Agent job to run a backup at 22:00 Monday through Friday.<\/p>\n<p>We have released SQL Server Agent packages for Ubuntu, RedHat Enterprise Linux, and SUSE Linux Enterprise Server that you can <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-setup-sql-agent\">install via apt-get, yum, and zypper<\/a>. Once you install these packages, you can create T-SQL Jobs using SSMS, sqlcmd, and other GUI and command line tools.<\/p>\n<p>Here is a simple example:<\/p>\n<ul>\n<li><b>Create a job<\/b><\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">CREATE DATABASE SampleDB ;<\/span><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">USE msdb ;<\/span><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">GO<\/span><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">EXEC dbo.sp_add_job<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@job_name = N&#8217;Daily SampleDB Backup&#8217; ;<\/span><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">GO<\/span><\/p>\n<ul>\n<li><b>Add one or more job steps<\/b><\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">EXEC sp_add_jobstep<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@job_name = N&#8217;Daily SampleDB Backup&#8217;,<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@step_name = N&#8217;Backup database&#8217;,<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@subsystem = N&#8217;TSQL&#8217;,<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@command = N&#8217;BACKUP DATABASE SampleDB TO DISK = \\<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">N&#8221;\/var\/opt\/mssql\/data\/SampleDB.bak&#8221; WITH NOFORMAT, NOINIT, \\<\/span><\/p>\n<p style=\"padding-left: 120px\"><span style=\"font-family: 'Courier New'\">NAME = &#8221;SampleDB-full&#8221;, SKIP, NOREWIND, NOUNLOAD, STATS = 10&#8242;,<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@retry_attempts = 5,<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@retry_interval = 5 ;<\/span><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">GO<\/span><\/p>\n<ul>\n<li><strong>Create a job schedule<\/strong><\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">EXEC dbo.sp_add_schedule<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@schedule_name = N&#8217;Daily SampleDB&#8217;,<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@freq_type = 4,<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@freq_interval = 1,<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@active_start_time = 233000 ;<\/span><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">USE msdb ;<\/span><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">GO<\/span><\/p>\n<ul>\n<li><b>Attach the schedule and add the job server<\/b><b><\/b><\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">EXEC sp_attach_schedule<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@job_name = N&#8217;Daily SampleDB Backup&#8217;,<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@schedule_name = N&#8217;Daily SampleDB&#8217;;<\/span><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">GO<\/span><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">EXEC dbo.sp_add_jobserver<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@job_name = N&#8217;Daily SampleDB Backup&#8217;,<\/span><\/p>\n<p style=\"padding-left: 90px\"><span style=\"font-family: 'Courier New'\">@server_name = N'(LOCAL)&#8217;;<\/span><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">GO<\/span><\/p>\n<ul>\n<li><b>Start job<\/b><\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">EXEC dbo.sp_start_job N&#8217; Daily SampleDB Backup&#8217; ;<\/span><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-family: 'Courier New'\">GO<\/span><\/p>\n<h2>Limitations:<\/h2>\n<p>The following types of SQL Agent jobs are not currently supported on Linux:<\/p>\n<ul>\n<li>Subsystems: CmdExec, PowerShell, Replication Distributor, Snapshot, Merge, Queue Reader, SSIS, SSAS, SSRS<\/li>\n<li>Alerts<\/li>\n<li>DB Mail<\/li>\n<li>Log Shipping<\/li>\n<li>Log Reader Agent<\/li>\n<li>Change Data Capture<\/li>\n<\/ul>\n<h2>Get started<\/h2>\n<p>If you\u2019re ready to get started with SQL Server on Linux, here\u2019s how to <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-setup-sql-agent\">install the SQL Server Agent package via apt-get, yum, and zypper.<\/a> And here\u2019s how to <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-run-sql-server-agent-job\">create your first T-SQL job and show you to use SSMS with SQL Agent<\/a>.<\/p>\n<h2>Learn more<\/h2>\n<ul>\n<li>Read <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/\">detailed documentation<\/a>.<\/li>\n<li><a href=\"https:\/\/info.microsoft.com\/sql-server-on-linux-town-hall-high-availability-register.html\">Register<\/a> for the next Engineering Town Hall webinar.<\/li>\n<li>If you have a workload ready to run on SQL Server v.Next, sign up for the <a href=\"http:\/\/sqlservervnexteap.azurewebsites.net\/\">SQL Server Early Adoption Program (EAP)<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In keeping with our goal to enable SQL Server features across all platforms supported by SQL Server, Microsoft is excited to announce the preview of SQL Server Agent on Linux in SQL Server vNext Community Technology Preview (CTP) 1.4. SQL Server Agent is a component that executes scheduled administrative tasks, called \u201cjobs.\u201d Jobs contain one<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2409],"content-type":[2424,2448],"topic":[2475],"coauthors":[2487],"class_list":["post-19165","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2017-on-linux","content-type-best-practices","content-type-updates","topic-oltp-database-management","review-flag-1593580427-503","review-flag-1-1593580431-15","review-flag-4-1593580446-456","review-flag-5-1593580452-31"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server on Linux: Running jobs with SQL Server Agent - Microsoft SQL Server 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.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server on Linux: Running jobs with SQL Server Agent - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"In keeping with our goal to enable SQL Server features across all platforms supported by SQL Server, Microsoft is excited to announce the preview of SQL Server Agent on Linux in SQL Server vNext Community Technology Preview (CTP) 1.4. SQL Server Agent is a component that executes scheduled administrative tasks, called \u201cjobs.\u201d Jobs contain one\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-17T16:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server on Linux: Running jobs with SQL Server Agent\",\"datePublished\":\"2017-03-17T16:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/\"},\"wordCount\":454,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/\",\"name\":\"SQL Server on Linux: Running jobs with SQL Server Agent - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2017-03-17T16:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server on Linux: Running jobs with SQL Server Agent\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server on Linux: Running jobs with SQL Server Agent - Microsoft SQL Server 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.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server on Linux: Running jobs with SQL Server Agent - Microsoft SQL Server Blog","og_description":"In keeping with our goal to enable SQL Server features across all platforms supported by SQL Server, Microsoft is excited to announce the preview of SQL Server Agent on Linux in SQL Server vNext Community Technology Preview (CTP) 1.4. SQL Server Agent is a component that executes scheduled administrative tasks, called \u201cjobs.\u201d Jobs contain one","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2017-03-17T16:00:00+00:00","article_modified_time":"2024-01-23T06:50:45+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server on Linux: Running jobs with SQL Server Agent","datePublished":"2017-03-17T16:00:00+00:00","dateModified":"2024-01-23T06:50:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/"},"wordCount":454,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/","name":"SQL Server on Linux: Running jobs with SQL Server Agent - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2017-03-17T16:00:00+00:00","dateModified":"2024-01-23T06:50:45+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/17\/sql-server-on-linux-running-jobs-with-sql-server-agent\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server on Linux: Running jobs with SQL Server Agent"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/19165","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=19165"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/19165\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=19165"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=19165"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=19165"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=19165"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=19165"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=19165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}