SQLSERVER JOB无法执行
错误提示:
Message Executed as user: WORKGROUP\NSDZHSCMFP01$. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 22:37:48 Error: 2018-05-24 22:37:48.49 Code: 0xC00291EC Source: DELETE FROM SAP TABLES IN DB2 PRD(2011) Execute SQL Task Description: Failed to acquire connection "SAP_PRD_NEW.SAPSR3". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Error: 2018-05-24 22:37:48.49 Code: 0xC00291EC Source: DELETE FROM SAP TABLES IN DB2 PRD(2012) Execute SQL Task Description: Failed to acquire connection "SAP_PRD_NEW.SAPSR3". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Error: 2018-05-24 22:37:48.49 Code: 0xC00291EC Source: drop table ZSTPO_OUTBS Execute SQL Task Description: Failed to acquire connection "SAP_PRD_NEW.SAPSR3". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Error: 2018-05-24 22:37:48.49 Code: 0xC00291EC Source: DELETE FROM SAP TABLES IN DB2 PRD(2013) Execute SQL Task Description: Failed to acquire connection "SAP_PRD_NEW.SAPSR3". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 22:37:48 Finished: 22:37:48 Elapsed: 0.328 seconds. The package execution failed. The step failed.
解决方法:
1、首先重启SQLAGETN,看SCHEDULE JOB能否正常运行
2、将SQL AGENT换成administrator,后重启即可