How to Use the Same Schedule for Multiple SQL Server Agent Jobs (T-SQL)

When you create a SQL Server Agent job, you have the option of creating a new schedule for that job or using one that already exists.

Job schedules can be managed independently of jobs. You can use sp_add_schedule to create the schedule and sp_attach_schedule to attach the schedule to a job.

This enables you to attach the same schedule to multiple jobs.

Continue reading

Create a SQL Server Agent Job using T-SQL

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs in SQL Server.

T-SQL includes a large collection of stored procedures that deal with SQL Server Agent jobs.

Here, we’ll use some of them to create and schedule a SQL Server Agent job.

You can also create SQL Server Agent jobs via the GUI (in SSMS) if you prefer.

Continue reading

How to Enable the SQL Server Agent XPs using T-SQL

If you’re creating a SQL Server Agent job for the first time, you might find that you need to enable the SQL Server Agent extended stored procedures (SQL Server Agent XPs) first.

When you use the SQL Server Management Studio (SSMS) tool to start the SQL Server Agent service, these extended stored procedures are enabled automatically.

When you use T-SQL, you can enable the SQL Server Agent XPs with the sp_configure stored procedure.

Continue reading