预定的DTS [英] Scheduled DTS
问题描述
嗨！
每当我手动运行时，我都安排从MySQL进行DTS导入
（右键单击DTS包）它运行通过没有任何问题。
但按时间表触发它并不起作用！？
只是为了排除有关用户的任何问题/角色，我创建了一个DTS，以便将
导出文件导出到我的桌面到EXCEL表。手动导出
按计划导出工作正常。
我的应用程序日志显示以下错误消息：
事件类型：警告
事件来源：SQLSERVERAGENT
活动类别：工作引擎
活动编号：208
日期：2005年6月8日
时间：10：05：02 AM
用户：N / A
电脑：**** *
描述：
SQL Server计划作业''ImportFromMySQL''
（0xC89612CE034F6642BD585B048DBC0F06） - 状态：失败 - 调用：
2005-06-08 10:05:02 - 消息：工作失败了。该作业由
Schedule 22（ImportFromMySQL）调用。最后一步是第1步
（ImportFromMySQL）。
有人知道什么是错的！？
Hi!
I scheduled a DTS-Import from MySQL, whenever I run it manually
(Right-Click on the DTS package) it runs through without any problems.
But firing it by a schedule doesn''t work!?
Just to exclude any issues regarding users/roles, I created a DTS to
export files to my desktop to an EXCEL-sheet. Manually export as well
as scheduled export works fine.
My Application Log shows me following error message:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 6/8/2005
Time: 10:05:02 AM
User: N/A
Computer: *****
Description:
SQL Server Scheduled Job ''ImportFromMySQL''
(0xC89612CE034F6642BD585B048DBC0F06) - Status: Failed - Invoked on:
2005-06-08 10:05:02 - Message: The job failed. The Job was invoked by
Schedule 22 (ImportFromMySQL). The last step to run was step 1
(ImportFromMySQL).
Anybody know what''s wrong!?
推荐答案
确保运行作业的帐户具有与用户帐户相同的
权限来检索和导出。当您手动运行DTS包时，您将在
的上下文中运行它您的用户名和当前运行的机器
企业管理器（即，您使用工作站来管理服务器）。
当作业被安排时，它是在
帐户的上下文中运行的SQL服务器正在运行，以及从服务器的角度来看
。
HTH，
Stu
Be sure that the account under which the job is running has the same
permissions to retrieve and export as your user account does. When you
run a DTS package manually, you are running it under the context of
your username and the machine on which you are currently running
Enterprise Manager (ie, you use your workstation to manage a server).
When the job is scheduled, it is running under the context of the
account by which SQL Server is running, as well as from the perspective
of the server.
HTH,
Stu
" Peter Neumaier" < Pe的************ @ gmail.com>在消息中写道
news：11 ********************** @ g44g2000cwa.googlegr oups.com ...
"Peter Neumaier" <Pe************@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
嗨！
每当我手动运行它时，我都安排从MySQL进行DTS导入
（右键单击DTS包）它运行时没有任何问题。但是按时间表触发它并不起作用！？
为了排除有关用户/角色的任何问题，我创建了一个DTS来将文件导出到我的桌面到EXCEL表。手动导出以及按计划导出工作正常。
我的应用程序日志显示以下错误消息：
事件类型：警告
事件来源： SQLSERVERAGENT
活动类别：工作引擎
活动编号：208
日期：2005年6月8日
时间：上午10:05:02
用户：N / A
计算机：*****
描述：
SQL Server计划作业''ImportFromMySQL''
（0xC89612CE034F6642BD585B048DBC0F06） - 状态：失败 - 调用于：
2005 -06-08 10:05:02 - 消息：作业失败了。该作业由附表22（ImportFromMySQL）调用。最后一步是第1步
（ImportFromMySQL）。
有人知道什么是错的！？
Hi!
I scheduled a DTS-Import from MySQL, whenever I run it manually
(Right-Click on the DTS package) it runs through without any problems.
But firing it by a schedule doesn''t work!?
Just to exclude any issues regarding users/roles, I created a DTS to
export files to my desktop to an EXCEL-sheet. Manually export as well
as scheduled export works fine.
My Application Log shows me following error message:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 6/8/2005
Time: 10:05:02 AM
User: N/A
Computer: *****
Description:
SQL Server Scheduled Job ''ImportFromMySQL''
(0xC89612CE034F6642BD585B048DBC0F06) - Status: Failed - Invoked on:
2005-06-08 10:05:02 - Message: The job failed. The Job was invoked by
Schedule 22 (ImportFromMySQL). The last step to run was step 1
(ImportFromMySQL).
Anybody know what''s wrong!?
http://support.microsoft.com/default...b ; en-us; 269074
Simon
http://support.microsoft.com/default...b;en-us;269074
Simon
您是否在企业管理器中连接到本地计算机并且
试图运行保存在服务器上的软件包？如果是这样的话，请运行
包裹，然后远程进入服务器并从那里运行。
基本上是STU用lamans术语说的;）
are you connected in the Enterprise Manager to your local machine and
trying to run the package that is saved on the server? if so run the
package by remoting in to the server and running it from there.
basically what STU said in lamans terms ;)
这篇关于预定的DTS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
