sql 语句添加作业

use msdb
go

declare @sJobName sysname
declare @sDatabase sysname

declare @sCommand nvarchar(3200)

set @sDatabase = 'JetHr'
set @sJobName = 'Penseesoft Database Backup'

set @sCommand  =
'
backup database JetHr
to disk=''d:\aa.bak''

'
if exists (select * from dbo.sysjobs where name =@sJobName)
    exec sp_delete_job @job_name = @sJobName

exec sp_add_job @job_name = @sJobName

exec sp_add_jobstep @job_name = @sJobName,
   @step_name = 'backup',
   @subsystem = 'TSQL',
   @command = @sCommand,
   @database_name = @sDatabase

EXEC sp_add_jobschedule @job_name = @sJobName,
   @name = '23:00',
   @freq_type = 4, -- 每天
   @freq_interval = 1, --间隔
   @active_start_time = 230000 --开始时间