Urgent - DB connection through maintenance job is not working

  • 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

  • let me answer it myself.

    Fully qualifying the stored procedure fixed the issue...

    Its weird though

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply