Skip to content

Commit 75b5117

Browse files
author
MightyPen
committed
Fixing Issue 2245, typos. Also new 'tsql-AppliesTo-*.md' sans year.
1 parent ab51fc8 commit 75b5117

2 files changed

Lines changed: 8 additions & 6 deletions

File tree

‎docs/includes/tsql-appliesto-ss-xxxx-xxxx-xxx-md.md‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
<Token>**APPLIES TO:** ![yes](media/yes.png)SQL Server ![no](media/no.png)Azure SQL Database ![no](media/no.png)Azure SQL Data Warehouse ![no](media/no.png)Parallel Data Warehouse </Token>

‎docs/relational-databases/system-stored-procedures/sp-add-jobstep-transact-sql.md‎

Lines changed: 7 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
title: "sp_add_jobstep (Transact-SQL) | Microsoft Docs"
33
ms.custom: ""
4-
ms.date: "03/14/2017"
4+
ms.date: "03/15/2017"
55
ms.prod: sql
66
ms.prod_service: "database-engine"
77
ms.reviewer: ""
@@ -20,7 +20,8 @@ ms.author: "sstein"
2020
manager: craigg
2121
---
2222
# sp_add_jobstep (Transact-SQL)
23-
[!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]
23+
24+
[!INCLUDE[tsql-appliesto-ss-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss-xxxx-xxxx-xxx-md.md)]
2425

2526
Adds a step (operation) to a job.
2627

@@ -144,10 +145,10 @@ sp_add_jobstep [ @job_id = ] job_id | [ @job_name = ] 'job_name'
144145
The name of the user account to use when executing a [!INCLUDE[tsql](../../includes/tsql-md.md)] step. *user* is **sysname**, with a default of NULL. When *user* is NULL, the step runs in the job owner's user context on *database*. SQL Server Agent will include this parameter only if the job owner is a SQL Server sysadmin. If so, the given Transact-SQL step will be executed in the context of the given SQL Server user name. If the job owner is not a SQL Server sysadmin, then the Transact-SQL step will always be executed in the context of the login that owns this job, and the @database_user_name parameter will be ignored.
145146

146147
`[ @retry_attempts = ] retry_attempts`
147-
The number of retry attempts to use if this step fails. *retry_attempts*is **int**, with a default of **0**, which indicates no retry attempts.
148+
The number of retry attempts to use if this step fails. *retry_attempts* is **int**, with a default of **0**, which indicates no retry attempts.
148149

149150
`[ @retry_interval = ] retry_interval`
150-
The amount of time in minutes between retry attempts. *retry_interval*is **int**, with a default of **0**, which indicates a **0**-minute interval.
151+
The amount of time in minutes between retry attempts. *retry_interval* is **int**, with a default of **0**, which indicates a **0**-minute interval.
151152

152153
`[ @os_run_priority = ] run_priority`
153154
Reserved.
@@ -208,14 +209,14 @@ sp_add_jobstep [ @job_id = ] job_id | [ @job_name = ] 'job_name'
208209
> [!NOTE]
209210
> This example assumes that the `Weekly Sales Data Backup` job already exists.
210211
211-
```
212+
```sql
212213
USE msdb;
213214
GO
214215
EXEC sp_add_jobstep
215216
@job_name = N'Weekly Sales Data Backup',
216217
@step_name = N'Set database to read only',
217218
@subsystem = N'TSQL',
218-
@command = N'ALTER DATABASE SALES SET READ_ONLY',
219+
@command = N'ALTER DATABASE SALES SET READ_ONLY',
219220
@retry_attempts = 5,
220221
@retry_interval = 5 ;
221222
GO

0 commit comments

Comments
 (0)