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

Urgent - DB connection through maintenance job is not working Expand / Collapse
Author
Message
Posted Monday, August 19, 2013 8:57 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 6, 2014 6:55 AM
Points: 67, Visits: 239

What am I missing here

Exec maintenance plan fails for stored procedure, saying it could not find the object.
also the automatically created job is failing(no surprise )
BUT
If I create a job executing the same prodcedure directly on sql server agent , it works fine

the sp is very simple it has only "select 1" , what I am trying to say is , no system file access inside the sp.
my windows account or the user that sql agent is running on are are member of the sysadmin role.

thanks
Post #1485860
Posted Monday, August 19, 2013 10:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 6, 2014 6:55 AM
Points: 67, Visits: 239
let me answer it myself.

Fully qualifying the stored procedure fixed the issue...

Its weird though
Post #1485885
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse