Skip to content

Commit 53fc481

Browse files
TaojunshenTaojunshen
authored
Merge pull request #29222 from MicrosoftDocs/main
11/30/2023 PM Publish
2 parents e3e5ab5 + e548825 commit 53fc481

15 files changed

Lines changed: 737 additions & 574 deletions

‎azure-sql/database/maintenance-window.md‎

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,7 @@ description: Understand how the Azure SQL Database and Azure SQL Managed Instanc
55
author: WilliamDAssafMSFT
66
ms.author: wiassaf
77
ms.reviewer: wiassaf, mathoma, urosmil, scottkim
8-
ms.date: 10/23/2023
8+
ms.date: 11/30/2023
99
ms.service: sql-db-mi
1010
ms.subservice: service-overview
1111
ms.topic: conceptual
@@ -80,7 +80,6 @@ Choosing a maintenance window other than the default is available on all SLOs **
8080
- DC hardware
8181
- Fsv2 hardware
8282
- Hyperscale service tier with zone redundancy
83-
- Hyperscale serverless databases
8483
- Hyperscale elastic pools
8584

8685
<!-- Check Known limitations in azure-sql/database/service-tier-hyperscale.md as well -->

‎azure-sql/managed-instance/machine-learning-services-differences.md‎

Lines changed: 5 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ description: This article describes key differences between Machine Learning Ser
44
author: MashaMSFT
55
ms.author: mathoma
66
ms.reviewer: mathoma, wiassaf
7-
ms.date: 08/03/2022
7+
ms.date: 11/30/2023
88
ms.service: sql-managed-instance
99
ms.subservice: machine-learning
1010
ms.topic: conceptual
@@ -82,6 +82,10 @@ If you encounter out of memory errors in Azure SQL Managed Instance, review [sys
8282

8383
Machine Learning Services is currently not supported on [Azure SQL Managed Instance pools (preview)](instance-pools-overview.md).
8484

85+
## Outbound network access
86+
87+
Network access is disallowed or blocked and cannot be enabled. The outbound network connection for Azure SQL Managed Instance is not avaialble for Machine Learning Services.
88+
8589
## Next steps
8690

8791
- See the overview, [Machine Learning Services in Azure SQL Managed Instance](machine-learning-services-overview.md).

‎docs/linux/sql-server-linux-db-mail-sql-agent.md‎

Lines changed: 64 additions & 55 deletions
Original file line numberDiff line numberDiff line change
@@ -1,123 +1,132 @@
11
---
2-
title: DB Mail and Email Alerts with SQL Agent on Linux
3-
description: Learn how to use DB Mail and how to set up Email Alerts with SQL Server Agent (mssql-server-agent) on Linux.
2+
title: Database Mail and email alerts with SQL Server Agent on Linux
3+
description: Learn how to use Database Mail and how to set up Email Alerts with SQL Server Agent (mssql-server-agent) on Linux.
44
author: rwestMSFT
55
ms.author: randolphwest
6-
ms.date: 11/16/2023
6+
ms.date: 11/30/2023
77
ms.service: sql
88
ms.subservice: linux
99
ms.topic: conceptual
1010
ms.custom:
1111
- linux-related-content
1212
---
13-
# DB Mail and Email Alerts with SQL Agent on Linux
13+
# Database Mail and email alerts with SQL Server Agent on Linux
1414

1515
[!INCLUDE [SQL Server - Linux](../includes/applies-to-version/sql-linux.md)]
1616

17-
The following steps show you how to set up DB Mail and use it with SQL Server Agent (**mssql-server-agent**) on Linux.
17+
This article shows how to set up Database Mail and use it with SQL Server Agent (**mssql-server-agent**) on Linux.
1818

19-
## 1. Enable DB Mail
19+
## 1. Enable Database Mail
2020

2121
```sql
22-
USE master
22+
USE master;
2323
GO
24-
sp_configure 'show advanced options',1
24+
25+
sp_configure 'show advanced options', 1;
2526
GO
27+
2628
RECONFIGURE WITH OVERRIDE
2729
GO
28-
sp_configure 'Database Mail XPs', 1
30+
31+
sp_configure 'Database Mail XPs', 1;
2932
GO
30-
RECONFIGURE
33+
34+
RECONFIGURE;
3135
GO
3236
```
3337

3438
## 2. Create a new account
3539

3640
```sql
37-
EXECUTE msdb.dbo.sysmail_add_account_sp
38-
@account_name = 'SQLAlerts',
39-
@description = 'Account for Automated DBA Notifications',
40-
@email_address = 'sqlagenttest@gmail.com',
41-
@replyto_address = 'sqlagenttest@gmail.com',
42-
@display_name = 'SQL Agent',
43-
@mailserver_name = 'smtp.gmail.com',
44-
@port = 587,
45-
@enable_ssl = 1,
46-
@username = 'sqlagenttest@gmail.com',
47-
@password = '<password>'
41+
EXECUTE msdb.dbo.sysmail_add_account_sp @account_name = 'SQLAlerts',
42+
@description = 'Account for Automated DBA Notifications',
43+
@email_address = 'sqlagenttest@example.com',
44+
@replyto_address = 'sqlagenttest@example.com',
45+
@display_name = 'SQL Agent',
46+
@mailserver_name = 'smtp.example.com',
47+
@port = 587,
48+
@enable_ssl = 1,
49+
@username = 'sqlagenttest@example.com',
50+
@password = '<password>';
4851
GO
4952
```
5053

5154
## 3. Create a default profile
5255

5356
```sql
5457
EXECUTE msdb.dbo.sysmail_add_profile_sp
55-
@profile_name = 'default',
56-
@description = 'Profile for sending Automated DBA Notifications'
58+
@profile_name = 'default',
59+
@description = 'Profile for sending Automated DBA Notifications';
5760
GO
5861
```
5962

6063
## 4. Add the Database Mail account to a Database Mail profile
6164

6265
```sql
6366
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
64-
@profile_name = 'default',
65-
@principal_name = 'public',
66-
@is_default = 1 ;
67-
```
67+
@profile_name = 'default',
68+
@principal_name = 'public',
69+
@is_default = 1;
70+
GO
71+
```
6872

6973
## 5. Add account to profile
7074

7175
```sql
7276
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
73-
@profile_name = 'default',
74-
@account_name = 'SQLAlerts',
75-
@sequence_number = 1;
76-
```
77+
@profile_name = 'default',
78+
@account_name = 'SQLAlerts',
79+
@sequence_number = 1;
80+
GO
81+
```
7782

7883
## 6. Send test email
7984

80-
> [!NOTE]
81-
> You might have to go to your email client and enable the "allow less secure clients to send mail." Not all clients recognize DB Mail as an email daemon.
85+
You might have to go to your email client and enable the **allow less secure clients to send mail** option. Not all clients recognize Database Mail as an email daemon.
8286

83-
```
87+
```sql
8488
EXECUTE msdb.dbo.sp_send_dbmail
85-
@profile_name = 'default',
86-
@recipients = 'recipient-email@gmail.com',
87-
@Subject = 'Testing DBMail',
88-
@Body = 'This message is a test for DBMail'
89+
@profile_name = 'default',
90+
@recipients = 'recipient-email@example.com',
91+
@subject = 'Testing DBMail',
92+
@body = 'This message is a test for DBMail'
8993
GO
9094
```
9195

92-
## 7. Set DB Mail Profile using mssql-conf or environment variable
96+
## 7. Set Database Mail profile using mssql-conf or environment variable
9397

94-
You can use the mssql-conf utility or environment variables to register your DB Mail profile. In this case, let's call our profile default.
98+
You can use the **mssql-conf** utility, or environment variables, to register your Database Mail profile. In this case, let's call our profile `default`.
9599

96-
```bash
97-
# via mssql-conf
98-
sudo /opt/mssql/bin/mssql-conf set sqlagent.databasemailprofile default
99-
# via environment variable
100-
MSSQL_AGENT_EMAIL_PROFILE=default
101-
```
100+
- Set via **mssql-conf**:
101+
102+
```bash
103+
sudo /opt/mssql/bin/mssql-conf set sqlagent.databasemailprofile default
104+
```
102105

103-
## 8. Set up an operator for SQLAgent job notifications
106+
- Set via environment variable:
107+
108+
```bash
109+
MSSQL_AGENT_EMAIL_PROFILE=default
110+
```
111+
112+
## 8. Set up an operator for SQL Server Agent job notifications
104113

105114
```sql
106115
EXEC msdb.dbo.sp_add_operator
107-
@name=N'JobAdmins',
108-
@enabled=1,
109-
@email_address=N'recipient-email@gmail.com',
110-
@category_name=N'[Uncategorized]'
116+
@name = N'JobAdmins',
117+
@enabled = 1,
118+
@email_address = N'recipient-email@example.com',
119+
@category_name = N'[Uncategorized]';
111120
GO
112121
```
113122

114123
## 9. Send email when 'Agent Test Job' succeeds
115124

116-
```
125+
```sql
117126
EXEC msdb.dbo.sp_update_job
118-
@job_name='Agent Test Job',
119-
@notify_level_email=1,
120-
@notify_email_operator_name=N'JobAdmins'
127+
@job_name = 'Agent Test Job',
128+
@notify_level_email = 1,
129+
@notify_email_operator_name = N'JobAdmins'
121130
GO
122131
```
123132

0 commit comments

Comments
 (0)