作业为何老是出问题？

[631799]

sqlserverAgent 服务已启动！

作业的内容如下：
update bbs_config set yesterday_announce=today_announce,top_announce=(case when today_announce>top_announce then today_announce else top_announce end),today_announce=0
go
update bbs_board set today_topic=0,today_article = 0


定时每天的0:00:00执行。
第二天发，昨天写的昨天名称前的图标为叉叉，上次执行的状态为失败，这是怎么回事啊？郁闷...

[clavier]

看看详细错误日志

[lzymagi]

贴出你的表结构和错误提示

[631799]

CREATE TABLE [dbo].[bbs_config] (
[config_id] [int] IDENTITY (1, 1) NOT NULL ,
[bbs_name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[bbs_url] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[index_name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[index_url] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[logo] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[admin_email] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[message_blank] [tinyint] NOT NULL ,
[email_pwd] [tinyint] NOT NULL ,
[email_reg] [tinyint] NOT NULL ,
[reg_audit] [tinyint] NOT NULL ,
[email_welcome] [tinyint] NOT NULL ,
[message_welcome] [tinyint] NOT NULL ,
[show_ip] [tinyint] NOT NULL ,
[show_address] [tinyint] NOT NULL ,
[online_ip] [tinyint] NOT NULL ,
[online_address] [tinyint] NOT NULL ,
[new_user] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[user_num] [numeric](18, 0) NOT NULL ,
[topic_num] [numeric](18, 0) NOT NULL ,
[announce_num] [numeric](18, 0) NOT NULL ,
[today_announce] [numeric](18, 0) NOT NULL ,
[yesterday_announce] [numeric](18, 0) NOT NULL ,
[top_announce] [numeric](18, 0) NOT NULL ,
[top_date] [datetime] NULL ,
[badwords] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[regwords] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[max_online] [int] NOT NULL ,
[max_date] [datetime] NULL ,
[hot_num] [int] NOT NULL ,
[page_count] [int] NOT NULL ,
[status] [tinyint] NOT NULL ,
[wh_intro] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[fastManager] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

[631799]

CREATE TABLE [dbo].[bbs_board] (
[board_id] [int] IDENTITY (1, 1) NOT NULL ,
[board_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[board_code] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[board_depth] [tinyint] NOT NULL ,
[board_order] [int] NOT NULL ,
[board_brief] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[board_pic] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[board_master] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[today_topic] [int] NOT NULL ,
[today_article] [int] NOT NULL ,
[last_visit] [datetime] NULL ,
[topic_num] [int] NOT NULL ,
[article_num] [int] NOT NULL ,
[is_lock] [tinyint] NOT NULL ,
[is_rz] [tinyint] NOT NULL ,
[is_login] [tinyint] NULL ,
[rz_user] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[lastpost] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Boardsetting] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[status] [tinyint] NOT NULL
) ON [PRIMARY]
GO

[631799]

up myself.

[野马]

up

[Liroyal]

什么错误?

[631799]

顺便再问一下：

多个作业发生同一时刻，会不会冲突啊？？？

[zjcxc]

不写错,看不出是什么原因

多个作业发生同一时刻，会不会冲突跟你的作业处理内容有关

[beckylucky]

是啊
你要把错误写出来阿！

[sdenli]

如果作业失败怎么办啊？比如说我每年都要进行一次的作业。如果失败了那肯定会对整个流程有影响的