weixin_43179501的博客

DB2 select TARGETCOLUMNNAME, ISADD from SYNC_COLUMN where SYNCTABLEID in ( select id from SYNC_TABLE where CLIENTCODE = 'xxx' and TARGETTABLENAME in ( select TABNAME from SYSCAT.TABLES where TABSCHEMA = 'xxx') )

CREATE proc hh_createjob --创建虚拟文件 @jobname varchar(100) = 'Product_Time_Replace',--作业名称 @sql varchar(8000) = 'exec Limis_Product_Time_Replace',--要执行的命令 @dbname sysname = 'SPC',--默认为当前的数据库名 @time int = 170000 --开始执行时间,对于重复执行的作业,将从0点到23:59分 1

SELECT [sJOB].[job_id] AS [作业ID] , [sJOB].[name] AS [作业名] , CASE WHEN [sJOBH].[run_date] IS NULL OR [sJOBH].[run_time] IS NULL THEN NULL ELSE CAST(CAST([sJOBH].[run_date] AS CHAR(8)) + ' '