第541章谋划（上） (3 / 6)
         SELECT @command = NULL

         /*

         ** Security Check: require sysadmin

         */

         IF (ISNULL(IS_SRVROLEMEMBER('sysadmin'),0) = 0)

         BEGIN

         RAISERROR(21089,16,-1)

         RETURN (1)

         END

         -- use the job_id and the agent type to retrieve the agent command

         -- line, only one agent command step is allowed in a job

         SELECT @command = command FROM msdb.dbo.sysjobsteps

         WHERE job_id = @job_id AND LOWER(subsystem collate SQL_Latin1_General_CP1_CS_AS) = LOWER(@agenttype collate SQL_Latin1_General_CP1_CS_AS)

         -- purge all instances of '-offload servername' from the agent command line

  The content is not finished, continue reading on the next page

更多完整内容阅读登陆

《墨缘文学网，https://wap.mywenxue.org》