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 reading