In SQL Server, you can use the sp_update_job stored procedure to modify an existing SQL Server Agent job.
SQL Server
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.
Modify a SQL Server Agent Schedule (T-SQL)
SQL Server Agent schedules can be managed independently of jobs. This means you can update the schedule directly without updating the job itself.
You can do this with the sp_update_schedule stored procedure.
sp_add_schedule vs sp_add_jobschedule in SQL Server: What’s the Difference?
If you’re in the process of creating a SQL Server Agent job with T-SQL, you may be wondering whether to create its schedule with the sp_add_schedule stored procedure or the sp_add_jobschedule procedure.
Here’s a quick explanation of the difference between these two procedures.
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.
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.
How to Run a SQL Server Agent Job using T-SQL
When you first create a SQL Server Agent job, you might want to do a quick test to see if it’s going to actually run without any issues.
This is quite straightforward when using the SSMS GUI, but how do you do it in T-SQL?
Answer: The sp_start_job stored procedure.
How to Fix: “SQLServerAgent is not currently running…”
If you’ve created a SQL Server Agent job, and you’re now trying to test it to see if it will run properly, you may encounter an ugly error message that reads, among other things, “SQLServerAgent is not currently running so it cannot be notified of this action”.
Fortunately, this is easy to fix.
Enable SQL Server Agent via SSMS
If you were trying to create a SQL Server Agent job for the first time, but a message popped up that confused you, read on.