SQL Server Job Scheduling

-- Create a job
Exec sp_add_job @ job_name = job_employee_insert,
@ Enabled =
1,
@ Description = 'perform operations at everyday ',
@ Start_step_id = 1,
@ Owner_login_name
= Sa
-- Add a new job executed by the SQLServerAgent Service
Exec sp_add_jobserver @ job_name =
Job_employee_insert
Go
-- Create Job Scheduling
Exec sp_add_jobschedule @ job_name =
Job_employee_insert,
@ Name = 'test Job Scheduling _ policy ',
@ Freq_type =
4,
@ Freq_interval = 1,
@ Active_start_time =
113000
Go
-- Add a step (operation) to the job
Exec sp_add_jobstep @ job_name =
Job_employee_insert,
@ Step_name = bakdata,
@ Subsystem = tsql,
@ Command
= 'Exec sp_employee_insert ',
@ Database_name = Policy
Go