Install the SQL Server Agent Extension on Azure Data Studio

One of the cool things about Azure Data Studio is that you can install extensions to extend its capabilities. One of those extensions is the SQL Server Agent extension.

This extension allows you to do stuff like create jobs, view jobs, view job history, stop/start jobs, etc.

This article shows you how to install the SQL Server Agent extension on Azure Data Studio.

Continue reading

Add a Job Step to an Existing SQL Server Agent Job (T-SQL)

When you create a SQL Server Agent job with T-SQL, you use the sp_add_jobstep stored procedure to add each job step.

If you ever need to add a new step to that job, you can use sp_add_jobstep once again to add the new job step.

But you may also need to modify the existing step, depending on how you’d like the job to progress through the steps.

Continue reading

Update a Job Step for a SQL Server Agent Job (T-SQL)

In SQL Server, you can use the sp_update_jobstep stored procedure to modify an existing job step of a SQL Server Agent job.

When you create a SQL Server Agent job, you create one or more job steps for that job. The sp_update_jobstep procedure allows you to update a specific job step independent of the actual job or any other job steps.

Continue reading