Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Job failed Expand / Collapse
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: Monday, November 16, 2015 3:09 PM
Points: 57, Visits: 173
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



Group: General Forum Members
Last Login: Thursday, October 20, 2016 4:13 PM
Points: 20,009, Visits: 18,250
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...


Posting Performance Based Questions - Gail Shaw
Post #1402608
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse