I run a stored procedure manually each day without fail using Query
Analyzer.I.E. I right click in the browser window on the stored
procedure hit open and execute. I am trying to get my "DBA" to
schedule this job in Enterprise manager and they keep getting syntax
errors that make no sense and keep asking me to fix the code.
Is there any difference in how the job scheduler executes a procedure
vrs doing it in Query analyzer via Open/Execute that requires a
different SQL syntax??? Im thinking that this problem is not the code
but a permissions issue What are your thoughts?