I wrote this post, because it may not be immediately apparent how to find the SQL Server Agent jobs in Azure Data Studio once you’ve installed the SQL Server Agent Extension.
In SSMS, the SQL Server Agent can be hard to miss, but in Azure Data Studio, it can be hard to find!
Or perhaps you’re not even aware that you need the extension, and you may be searching for jobs that simply can’t be found.
Here’s how to locate the SQL Server Agent jobs in Azure Data Studio.
Continue readingOften the quickest way to get a list of SQL Server Agent jobs is to simply expand the SQL Server Agent node in the SSMS Object Explorer.
But that’s not the only way. And depending on your environment, it might not even be an option. If you don’t have SSMS or a database tool that allows you to see the SQL Server Agent jobs, you may need to use T-SQL instead.
In this article, I present three options for returning a list of SQL Server Agent jobs when using T-SQL.
Continue readingIn this article, I present four options for returning SQL Server Agent job history data.
Continue readingThis article shows you how to view the history of a SQL Server Agent job in the SQL Server Management Studio (SSMS) GUI.
Continue readingThis article shows you how to view the history of a SQL Server Agent job in Azure Data Studio.
Continue readingIn SQL Server, the sp_help_schedule stored procedure returns information about schedules in the SQL Server Agent.
This article provides an overview of this stored procedure including examples.
Continue readingIn SQL Server, the sp_help_jobschedule stored procedure returns information about the scheduling of jobs.
This article provides an overview of this stored procedure including examples.
Continue readingIn SQL Server, you can use the sp_rename stored procedure to rename an object, including a table.
Most of the other major RDBMs allow you to rename a table with the ALTER TABLE statement, but this isn’t the case with SQL Server.
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 readingIn SQL Server, you can use the sp_update_job stored procedure to modify an existing SQL Server Agent job.