title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | dev_langs | monikerRange | |
---|---|---|---|---|---|---|---|---|---|---|
jobs.sp_start_job (Azure Elastic Jobs) (Transact-SQL) |
jobs.sp_start_job starts an existing job in the Azure Elastic Jobs service for Azure SQL Database. |
WilliamDAssafMSFT |
wiassaf |
10/30/2023 |
sql |
system-objects |
reference |
|
=azuresqldb-current |
[!INCLUDE Azure SQL Database]
Starts an existing job in the Azure Elastic Jobs service for Azure SQL Database.
This stored procedure shares the name of sp_start_job
with a similar object in [!INCLUDE ssnoversion-md] for the [!INCLUDE ssnoversion-md] Agent service. For information about the [!INCLUDE ssnoversion-md] Agent version, see sp_start_job (Transact-SQL).
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
[jobs].sp_start_job [ @job_name = ] 'job_name'
[ , [ @job_execution_id = ] job_execution_id OUTPUT ]
The name of the job to start. job_name is nvarchar(128), with no default.
Output parameter that will be assigned the job execution's ID. job_version is uniqueidentifier.
0 (success) or 1 (failure)
By default, members of the sysadmin fixed server role can execute this stored procedure. Only members of sysadmin can use this stored procedure to edit the attributes of jobs that are owned by other users.