34,873
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
escaper 2001-12-18
- 打赏
- 举报
多谢,多谢
mmzxg 2001-12-17
- 打赏
- 举报
sql-dmo到底怎用呢，这么多人提起，要学习才行
昵称被占用了 2001-12-17
- 打赏
- 举报
没用过sql-dmo,帮不到你
escaper 2001-12-16
- 打赏
- 举报
to: haihaiwer , 能给一个在程序中动态创建job的实例吗? 用sql-dmo最好了
昵称被占用了 2001-12-16
- 打赏
- 举报
一个例子:加一个JOB,修改PUBS的TITLES表的TITLE字段,在前面加字母G,SQL语句如下(好多参数,自己看):
exec msdb..sp_addtask 'Test', @subsystem = 'TSQL', @server = null, @username = null, @databasename = 'pubs', @enabled = 1, @freqtype = 8, @freqinterval = 1, @freqsubtype = 1, @freqsubinterval = 0, @freqrelativeinterval = 1, @freqrecurrencefactor = 1, @activestartdate = 20011216, @activeenddate = 99991231, @activestarttimeofday = 0, @activeendtimeofday = 235959, @runpriority = 0, @emailoperatorname = null, @retryattempts = 0, @retrydelay = 0, @loghistcompletionlevel = 2, @emailcompletionlevel = 0, @command = 'update titles
set title=''G''+ title', @tagadditionalinfo = null, @description = null, @tagobjectid = 0, @tagobjecttype = 0, @cmdexecsuccesscode = 0
exec msdb..sp_addtask 'Test', @subsystem = 'TSQL', @server = null, @username = null, @databasename = 'pubs', @enabled = 1, @freqtype = 8, @freqinterval = 1, @freqsubtype = 1, @freqsubinterval = 0, @freqrelativeinterval = 1, @freqrecurrencefactor = 1, @activestartdate = 20011216, @activeenddate = 99991231, @activestarttimeofday = 0, @activeendtimeofday = 235959, @runpriority = 0, @emailoperatorname = null, @retryattempts = 0, @retrydelay = 0, @loghistcompletionlevel = 2, @emailcompletionlevel = 0, @command = 'update titles
set title=''G''+ title', @tagadditionalinfo = null, @description = null, @tagobjectid = 0, @tagobjecttype = 0, @cmdexecsuccesscode = 0
昵称被占用了 2001-12-16
- 打赏
- 举报
能!
