"Simon Hayes" <sql@hayes.ch> wrote in message
news:416f94f2_3@news.bluewin.ch...
>
> "Philip Mette" <philipdm@msn.com> wrote in message
> news:96a56e66.0410140604.57b47ad8@posting.google.com...
> >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?
>
> There should be no difference in syntax, but it may be a permissions
issue,
> depending on who owns the job. Without seeing the exact errors, though,
it's
> impossible to make any real suggestions. It would also be useful to know
the
> version of MSSQL, who owns the job that's failing, and what the stored
> procedure does (just data manipulation, or does it use xp_cmdshell for
> something etc).
>
> Simon
>
>

"Philip Mette" <philipdm@msn.com> wrote in message
news:96a56e66.0410140604.57b47ad8@posting.google.com...
>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?