MS SQL Server - Alert Response Execute Job

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Alert Response Execute Job

Thom

2006-02-02, 1:23 pm

I would like to have an alert execute a job as a response, but I also need to
have the error text passed into the job.
Is this possible or is there another way?

Uri Dimant

2006-02-05, 9:23 am

Thom
>I would like to have an alert execute a job as a response,
Can you elaborate a little bit?

> have the error text passed into the job.

Yes , you have an option to define an output file to get out info.
(Step-Advanced--Output file)

"Thom" <Thom@discussions.microsoft.com> wrote in message
news:1E82BB52-6536-4D37-965D- 3896A3CC5C45@microso
ft.com...
>I would like to have an alert execute a job as a response, but I also need
>to
> have the error text passed into the job.
> Is this possible or is there another way?
>
>

Sponsored Links