全部博文
-
编辑 删除
在sql server2012中建立定时任务[转载]
1.新建一张测试表 USE [Job_Test] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Table_Job]( [ID] [uniqueidentifier] NOT NULL, [Name] [varchar](256) NULL, CONSTRAINT [PK_Table_Job] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO 2.启动作业服务代理 2.右键新建作业 .
