Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Job failed Expand / Collapse
Author
Message
Posted Thursday, January 3, 2013 2:02 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 2:22 PM
Points: 55, Visits: 165
MSSQL2k job that runs ActiveX Script to cleanup / delete backup files older than 7 days. Had been running without any issue and seems like a hiccup last night. Job failed with following:

Executed as user: abc
Error Code: 0
Error Source = Microsoft VBScript runtime error
Error Description: Permission denied.

My questions are
1) Is it in fact a permission issue? is the description somewhat reliable?
2) Granted, I'm not sure what happened on the UNC path (I do not have access to the servers - only server admins do); what reason(s) could possibly have happened that would throw the following error?

The failed job is scheduled at 10:30pm. There's another job that runs from a different server using the same username doing the same exact thing for the same UNC path with exception to the server name and runs at 11:00pm; this job completed without any issues.

Could it simply be just a glitch at the 10:30pm?
Post #1402553
Posted Thursday, January 3, 2013 4:23 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 6:02 PM
Points: 21,657, Visits: 15,326
Have you tried to rerun the job that failed?

If yes, did it succeed?




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1402608
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse