"Jeff" <it_consultant1@NO_SPAM.hotmail.com> wrote in message
news:OBDrpZm0GHA.4176@TK2MSFTNGP06.phx.gbl...
> Hey
>
> MS Sql Server 2005
>
> I have a scheduled task which failed. Where can I see the reason why it
> failed?
>
> By the way, in the Job Steps Properties window I listed (in the "command"
> field) up the stored procedures I want the task to execute:
> Hello_Publish
> Hello_SendEmail
>
> Any suggestions?
>
> Jeff
>

"Narayana Vyas Kondreddi" <answer***@hotmail.com> wrote in message
news:e6I$o6m0GHA.4648@TK2MSFTNGP04.phx.gbl...
> Sorry for asking the very obvious question, but have you checked the job
> history? Right click on the job and select 'View History'. Highlight the
> step that failed and see what the error message is.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Jeff" <it_consultant1@NO_SPAM.hotmail.com> wrote in message
> news:OBDrpZm0GHA.4176@TK2MSFTNGP06.phx.gbl...
>> Hey
>>
>> MS Sql Server 2005
>>
>> I have a scheduled task which failed. Where can I see the reason why it
>> failed?
>>
>> By the way, in the Job Steps Properties window I listed (in the "command"
>> field) up the stored procedures I want the task to execute:
>> Hello_Publish
>> Hello_SendEmail
>>
>> Any suggestions?
>>
>> Jeff
>>
>
>