Scheduling an sp

Hi All,
I hope I can explain this well.
I have an sp that populates certain tables with historical data and I've
scheduled
a job (using EM) that runs this sp on the first day of each quarter.
My question is, within the sp, if anything goes wrong, I do a rollback and
issue
a Return(5). Will this be interpeted as a failure within the job? Somehow I
think not.

So, how do I indicate failure to the job that schedules the sp?



Dan

Dan,

Add a RAISERROR statement to your stored procedure.

HTH

Jerry
"dan artuso" < dartuso@NOSPAMpagepe
arls.com> wrote in message
news:OjXqmJfxFHA.2924@TK2MSFTNGP15.phx.gbl...
> Hi All,
> I hope I can explain this well.
> I have an sp that populates certain tables with historical data and I've
> scheduled
> a job (using EM) that runs this sp on the first day of each quarter.
> My question is, within the sp, if anything goes wrong, I do a rollback and
> issue
> a Return(5). Will this be interpeted as a failure within the job? Somehow
> I think not.
>
> So, how do I indicate failure to the job that schedules the sp?
>
>
>
> Dan
>
>
>

Thanks Jerry

Dan


"Jerry Spivey" <jspivey@vestas-awt.com> wrote in message
news:u7haHMfxFHA.1148@TK2MSFTNGP11.phx.gbl...
> Dan,
>
> Add a RAISERROR statement to your stored procedure.
>
> HTH
>
> Jerry
> "dan artuso" < dartuso@NOSPAMpagepe
arls.com> wrote in message
> news:OjXqmJfxFHA.2924@TK2MSFTNGP15.phx.gbl... 
>
>