[MS SQL]Schedule a Procedure JOB 自動排程設定考資料

SQL SERVER procedure 自動排程設定考資料

Create a Job - SQL Server Agent | Microsoft Learn

sp_add_schedule (Transact-SQL) - SQL Server | Microsoft Learn

Schedule a Job - SQL Server Agent | Microsoft Learn

Simple way to create a SQL Server Job Using T-SQL (mssqltips.com)

 

  1. sp_add_job creates a new job
  2. sp_add_jobstep adds a new step in the job
  3. sp_add_jobschedule schedules a job for a specific date and time
  4. sp_add_jobserver adds the job to a specific server