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 )
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.