Hi I have a job created to execute two stored procedures: exec sp\_Import\_PopulateImportTables
exec sp\_Import If I run these two commands regularly (without a job) they work fine. But when I try to put them in a job I get this error: Executed as user: NT AUTHORITY\\SYSTEM. Could not find stored procedure 'sp\_Import\_PopulateImportTables'. [SQLSTATE 42000] (Error 2812). The step failed. This stored procedure is DEFINITELY in the database. What am I doing wrong here????? Thanks in advance!!!!!! any insight is greatly appreciated
But testing the connections through SSMS isn't the same as a job running under SQL Agent trying to connect... You may need to add the SQLBackups account as a named account on the linked server connection, depending on how you have them set up. You got some linked server pointers in this question
http://ask.sqlservercentral.com/questions/90047/please-help-login-failed.html [Posted as an answer at the request of the OP - see the comment trail under my other answer to see how we got here :)]
Hmm, either it has something to do with the executing account of sql server agent or you have the wrong db focus (or both). First the easy one: Try the FQDN of your db, e.g. Mydatabase.schemaName.MyProcedure or reconfigure your Jobstep and choose the right db in the drop down menue. Another hint: normally it is better to use usp_ instead of sp_ when naming user stored procedures (catchword: naming convention).