use msdb DECLARE @srv sysname SET @srv = CAST(SERVERPROPERTY('ServerName') AS sysname) select @srv select * from sysjobs UPDATE sysjobs SET originating_server = @srv select * from sysjobs
use msdb DECLARE @srv sysname SET @srv = CAST(SERVERPROPERTY('ServerName') AS sysname) select @srv select * from sysjobs UPDATE sysjobs SET originating_server = @srv select * from sysjobs
转载于:https://www.cnblogs.com/KiloNet/archive/2013/02/19/2686526.html