I found the issue. I assure you when I setup this job the proper database was selected. I found when I opened the job and edited the step....it was set...

Here is what the error says:

Executed as user: NT AUTHORITY\NETWORK SERVICE. Could not find stored procedure 'dbo.procedurename'. [SQLSTATE 42000] (Error 2812). The step failed.

The procedure is there!! Do you...

Sure. I have a step in a job that runs 'execute sp_dbo.processname @var1 = null, @var2 = null

The procedure, below, basically moves data from one place to another and sets...

I actually had most of that correct in my job. The only thing I was missing was the 'sp_'. But my job still errors. If I run the stored procedure...

I will test that out ASAP tomorrow and let you know what happens. Thanks for your help.

RRS