1.新建一张测试表 use [job_test] go /****** object: table [dbo].[table_job] script date: 2013/3/22 15:38:08 ******/ set ansi_nulls on go set quoted_identifier on go set ansi_padding on go create table [dbo].[table_job]( [id] [uniqueidentifi
1.新建一张测试表
use [job_test]
go
/****** object: table [dbo].[table_job] script date: 2013/3/22 15:38:08 ******/
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.右键新建作业
.
4.填写作业步骤，免备案空间，填写相应的sql
.
5.填写作业计划
6.检查作业运行是否有效
，网站空间，美国服务器