关于英文操作系统,后台任务管理任务名称出现乱码问题的解决办法


原因是由于tn_TaskDetails表的Name字段使用了varchar类型,应该为nvarchar类型。

具体修复脚本如下:

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_tn_TaskDetails_Name]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[tn_TaskDetails] DROP CONSTRAINT [DF_tn_TaskDetails_Name]
END
ALTER TABLE [dbo].[tn_TaskDetails] ALTER COLUMN [Name] [nvarchar](64) NOT NULL
ALTER TABLE [dbo].[tn_TaskDetails] ADD CONSTRAINT [DF_tn_TaskDetails_Name] DEFAULT ('') FOR [Name]
GO

DELETE FROM [dbo].[tn_TaskDetails]

INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'保存计数队列', N'0 0/1 * * * ?', N'Tunynet.Common.ExecCountQueueTask,Tunynet.BusinessComponents', 1, 0, 0,N'', N'', 1, N'', N'', NULL, 0)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'更新阶段计数', N'0 0/1 * * * ?', N'Tunynet.Common.UpdateStageCountTask,Tunynet.BusinessComponents', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 1)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'清除过期的提醒记录', N'0 10 0 * * ?"', N'Tunynet.Common.DeleteTrashReminderRecordsTask,Tunynet.BusinessComponents', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 1)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'保存访问记录队列', N'0 0/1 * * * ?', N'Tunynet.Common.ExecVisitQueueTask,Tunynet.BusinessComponents', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 0)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'每天清除邀请码', N'0 20 0 * * ?', N'Tunynet.Common.DeleteTrashInvitationCodesTask,Tunynet.BusinessComponents', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 1)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'发送邮件', N'0 0/3 * * * ?', N'Tunynet.Email.Tasks.EmailTask,Tunynet.Infrastructure', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 1)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'清理垃圾临时附件', N'0 0 1 * * ?', N'Tunynet.Common.DeleteTrashTemporaryAttachmentsTask,Tunynet.BusinessComponents', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 1)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'提交全文检索索引(每2分钟的开始)', N'0 0/2 * * * ?', N'Spacebuilder.Search.Tasks.LuceneIndexCommitTask,Spacebuilder.Common', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 1)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'优化全文检索索引(每天中午12点整)', N'0 0 12 * * ?', N'Spacebuilder.Search.Tasks.LuceneIndexOptimizeTask,Spacebuilder.Common', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 1)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'更新关注用户索引(每分钟第30秒)', N'30 0/2 * * * ?', N'Spacebuilder.Search.Tasks.FollowUserIndexTask,Spacebuilder.Common', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 1)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'更新用户在线状态(每分钟)', N'0 0/1 * * * ?', N'Tunynet.Common.Tasks.OnlineUserTask,Tunynet.BusinessComponents', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 0)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'定期移除过期的推荐内容', N'0 30 1 * * ?', N'Tunynet.Common.DeleteExpiredRecommendItemsTask,Tunynet.BusinessComponents', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 1)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'发送提醒', N'0 0/10 0 * * ?', N'Tunynet.Common.SendReminderTask,Tunynet.BusinessComponents', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 1)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'清理垃圾数据', N'0 0 2 * * ?', N'Tunynet.Common.DeleteTrashDataTask,Tunynet.BusinessComponents', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 1)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'更新置顶时间到期的帖子', N'0 40 0 * * ?', N'Spacebuilder.Bar.ExpireStickyThreadsTask,Spacebuilder.Bar', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 1)
INSERT [dbo].[tn_TaskDetails] ([Name], [TaskRule], [ClassType], [Enabled], [RunAtRestart], [IsRunning], [LastStart], [LastEnd], [LastIsSuccess], [NextStart], [StartDate], [EndDate], [RunAtServer]) VALUES (N'更新群组的成长值', N'0 50 0 * * ?', N'Spacebuilder.Group.CalculateGrowthValuesTask,Spacebuilder.Group', 1, 0, 0, N'', N'', 1, N'', N'', NULL, 1)


评论列表 0

暂无评论