Understanding the purpose of SQL Server Agent – (Part 2) Author: Basit A. Farooq Creating a job with Transact-SQL You can also use the store procedures in the msdb database. SQL Server includes system stored procedures for managing jobs, schedules, operators, and alerts. These are: dbo. sp_add_job, dbo.sp_add_job_step, dbo.sp_add_schedule,dbo.sp_attach_schedule, and dbo.sp_add_jobserver. Creating job using SQL Server system stored procedures To...