In 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 readingCategory: DBMS
Database Management Systems
Using sp_help_jobschedule in SQL Server
In 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 readingRename a Table in SQL Server (T-SQL)
In 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.
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 readingModify a SQL Server Agent Job (T-SQL)
In SQL Server, you can use the sp_update_job stored procedure to modify an existing SQL Server Agent job.
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.
Continue readingHow 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 readingCreate 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