我的SQL2005的作业中调用了一个SSIS包,就这一步。SSIS包单独执行没有问题,放在作业里就会出错。下面是5月1号及以后的错误日志,我看不太懂,希望对解决这个问题会有帮助!2009-05-01 07:11:37.21 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)2009-05-01 07:11:37.21 Server (c) 2005 Microsoft Corporation.
2009-05-01 07:11:37.21 Server All rights reserved.
2009-05-01 07:11:37.21 Server Server process ID is 1080.
2009-05-01 07:11:37.21 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2009-05-01 07:11:37.21 Server This instance of SQL Server last reported using a process ID of 2132 at 2009/04/30 20:00:31 (local) 2009/04/30 12:00:31 (UTC). This is an informational message only; no user action is required.
2009-05-01 07:11:37.21 Server Registry startup parameters:
2009-05-01 07:11:37.21 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2009-05-01 07:11:37.21 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2009-05-01 07:11:37.21 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2009-05-01 07:11:37.31 サーバー SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2009-05-01 07:11:37.31 サーバー Detected 1 CPUs. This is an informational message; no user action is required.
2009-05-01 07:11:37.62 サーバー Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2009-05-01 07:11:38.04 サーバー Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2009-05-01 07:11:40.76 サーバー Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2009-05-01 07:11:40.76 サーバー Database Mirroring Transport is disabled in the endpoint configuration.
2009-05-01 07:11:41.56 spid5s Starting up database 'master'.
2009-05-01 07:11:41.87 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2009-05-01 07:11:41.98 spid5s SQL Trace ID 1 was started by login "sa".
2009-05-01 07:11:42.01 spid5s Starting up database 'mssqlsystemresource'.
2009-05-01 07:11:42.32 spid5s Server name is 'DWH-SV\DWHSQL2005'. This is an informational message only. No user action is required.
2009-05-01 07:11:42.32 spid9s Starting up database 'model'.
2009-05-01 07:11:42.76 サーバー A self-generated certificate was successfully loaded for encryption.
2009-05-01 07:11:42.93 サーバー Server is listening on [ 'any' <ipv4> 4481].
2009-05-01 07:11:42.93 サーバー Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\DWHSQL2005 ].
2009-05-01 07:11:42.93 サーバー Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$DWHSQL2005\sql\query ].
2009-05-01 07:11:42.93 サーバー Server is listening on [ 127.0.0.1 <ipv4> 4482].
2009-05-01 07:11:42.93 サーバー Dedicated admin connection support was established for listening locally on port 4482.
2009-05-01 07:11:43.07 spid9s Clearing tempdb database.
2009-05-01 07:11:43.28 サーバー SQL Server is now ready for client connections. This is an informational message; no user action is required.
2009-05-01 07:11:43.31 spid12s Starting up database 'msdb'.
2009-05-01 07:11:43.31 spid13s Starting up database 'fresh'.
2009-05-01 07:11:43.81 spid14s Starting up database 'DataWareHouse_Mining'.
2009-05-01 07:11:43.81 spid15s Starting up database 'FRESHDB_TEST'.
2009-05-01 07:11:46.54 spid12s Starting up database 'AdventureWorks'.
2009-05-01 07:11:47.64 spid15s Starting up database 'Data Mining'.
2009-05-01 07:11:52.59 spid13s Starting up database 'AdventureWorksDW'.
2009-05-01 07:11:57.09 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2009-05-01 07:11:58.25 spid9s Starting up database 'tempdb'.
2009-05-01 07:12:00.63 spid5s Recovery is complete. This is an informational message only. No user action is required.
2009-05-01 07:12:00.63 spid12s The Service Broker protocol transport is disabled or not configured.
2009-05-01 07:12:00.63 spid12s The Database Mirroring protocol transport is disabled or not configured.
2009-05-01 07:12:00.82 spid12s Service Broker manager has started.
2009-05-02 00:00:05.68 spid16s This instance of SQL Server has been using a process ID of 1080 since 2009/05/01 7:12:00 (local) 2009/04/30 23:12:00 (UTC). This is an informational message only; no user action is required.
2009-05-07 00:00:22.65 spid20s This instance of SQL Server has been using a process ID of 1080 since 2009/05/01 7:12:00 (local) 2009/04/30 23:12:00 (UTC). This is an informational message only; no user action is required.
2009-04-30 09:34:32.82 spid51 Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2009-04-30 10:03:08.25 spid52 Using 'xpsqlbot.dll' version '2005.90.1399' to execute extended stored procedure 'xp_qv'.
This is an informational message only; no user action is required.
2009-04-30 10:03:08.36 spid52 Using 'xplog70.dll' version '2005.90.1399' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2009-04-30 20:00:31.15 サーバー SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2009-04-30 20:00:46.78 サーバー The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. This is an informational message only. No user action is required.
2009-04-30 20:00:47.08 サーバー エラー: 17054、重大度: 16、状態: 1。
2009-04-30 20:00:47.08 サーバー The current event was not reported to the Windows Events log. Operating system error = 1717(そのインターフェイスは認識されません。). You may need to clear the Windows Events log if it is full.
2009-04-30 20:00:53.25 spid12s Service Broker manager has shut down.
2009-04-30 20:00:58.23 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2009-04-30 20:00:58.87 サーバー The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x45b. Administrator should deregister this SPN manually to avoid client authentication errors.
メッセージ
[396] CPU のアイドル状態が定義されていません - OnIdle ジョブ スケジュールは機能しませんメッセージ
[364] Messenger サービスが開始されていません - NetSend 通知は送信されません