Format sysjobhistory datetime & duration Columns in SQL Server

If you’ve ever queried the sysjobhistory table in the msdb database, you’ll probably know that the datetime and duration columns are stored as integers.

In particular, when you query this table, the run_date, run_time, and duration columns are returned as integers, which can make it difficult to read.

Below is a query you can use to return this data in an easier to read format.

Continue reading

Create a SQL Server Agent Schedule with T-SQL

When using T-SQL, you can use the sp_add_schedule stored procedure to add a SQL Server Agent schedule.

This procedure creates the schedule, but it doesn’t attach it to any jobs. To attach it to a job, you must use the sp_attach_schedule procedure.

You can also use sp_add_jobschedule to create the schedule and attach it all with the same procedure.

Continue reading

How to Locate SQL Server Agent Jobs in Azure Data Studio

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 reading

3 Ways to Return a List of SQL Server Agent Jobs (T-SQL)

Often 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 reading