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)
- sp_add_job creates a new job
- sp_add_jobstep adds a new step in the job
- sp_add_jobschedule schedules a job for a specific date and time
- sp_add_jobserver adds the job to a specific server