SQL新建JOB

定时truncate表

估计是因为没打sp2的补丁，手动建立不成功，总是报错误，改用脚本

EXEC dbo.sp_add_job

@job_name = N'efip',

@enabled = 1

 

go

 

EXEC dbo.sp_add_jobserver

@job_name = N'efip',

@server_name = N'(LOCAL)'

 

go

 

EXEC sp_add_jobstep

@job_name = N'efip',

@step_name = N'truncate',

@subsystem = N'TSQL',

@command = N'truncate table dbo.Feip_OriginalData',

@retry_attempts = 5,

@retry_interval = 5 ,

@database_name='DB'

Go

 

Schedule手动建的，不过用脚本也行

EXEC sp_add_schedule

    @schedule_name = N'NightlyJobs' ,

    @freq_type = 4,

    @freq_interval = 1,

    @active_start_time = 010000 ;

GO

 

 

EXEC sp_attach_schedule

   @job_name = N'BackupDatabase',

   @schedule_name = N'NightlyJobs' ;

GO

 

EXEC sp_attach_schedule

   @job_name = N'RunReports',

   @schedule_name = N'NightlyJobs' ;

GO