用存储过程来添加预定作业
添加job
use sybmgmtdb
go
sp_sjobcreate @name='jname=job_clear_log_of_pmdb',@option='jdesc=truncate the log of database pmdb every hour,jproperties=shared'
go
use sybmgmtdb
go
sp_sjobcmd @name='jname=job_clear_log_of_pmdb',@option='add',@text='
use pmdb
dump tran pmdb with no_log
go'
go
添加调度
use sybmgmtdb
go
sp_sjobcreate @name='sname=sche_clear_log_of_pmdb',@option='repeats=1hours,starttime=00:00,endtime=23:59'
go
添加预定作业
use sybmgmtdb
go
sp_sjobcreate @name='sjname=sj_clear_log_of_pmdb',@option='server=job_server,jname=job_clear_log_of_pmdb,sname=sche_clear_log_of_pmdb'
go