使用ms sql server ,我能在程序中创建一个job,在job中写sql ,对表中的某个字段进行修改吗?

escaper 2001-12-16 04:49:19

...全文

78 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

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

昵称被占用了 2001-12-16