Post
Ask Question
ranjan ds

ranjan ds

  • NA
  • 3
  • 3.8k

SQL Server Job Agent Fails

Aug 19 2015 6:11 AM

Hi Xiong,


Now the task succeded. I will get u the msg what i am getting for success and for failure.

-------------For failure------------------------------

Message
The job failed. The Job was invoked by User WUNDERWEAR\dd1. The last step to run was step 1 (Update DDDRetail).

Message
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 32-bit
Copyright (C) Microsoft Corporation. All rights reserved. Started: 10:18:57 Error: 2015-08-18 10:19:13.04 Code: 0xC0016016
Source: DDDRetail Import SSIS Description: Failed to decrypt protected XML node
"DTS:Property" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information.
This error occurs when there is a cryptographic error. Verify that the correct key is available.
End Error Error: 2015-08-18 10:24:46.52 Code: 0xC0029183 Source: Remove Trans File from FTP FTP Task
Description: File represented by "/kde_0155/trans.txt" does not exist. End Error DTExec: The package execution returned DTSER_FAILURE (1).
Started: 10:18:57 Finished: 10:24:47 Elapsed: 350.612 seconds. The package execution failed. The step failed.


-------------For success------------------------------

Message
The job succeeded. The Job was invoked by Schedule 9 (Update DDDRetail - Night). The last step to run was step 1 (Update DDDRetail).

Message
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 32-bit
Copyright (C) Microsoft Corporation. All rights reserved. Started: 08:00:03 Error: 2015-08-19 08:00:14.69 Code: 0xC0016016
Source: DDDRetail Import SSIS Description: Failed to decrypt protected XML node
"DTS:Property" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information.
This error occurs when there is a cryptographic error. Verify that the correct key is available.
End Error DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 08:00:03 Finished: 08:22:19 Elapsed: 1336.21 seconds. The package executed successfully. The step succeeded.


when it is run by schedule 9 its successful, wen run from username it fails

Help me out with the problem.

Thanks

Ranjan DS


Answers (1)