Alert for a job step

hi.
I have a job with 5 steps.
I want a custom alert after the first step is executed reagrdless of whether it succeeds or fails on execution. I want to do a net send of the alert only after step1 is completed. How do i do this?
Thank you very much for the help.You can create step 2 as the send alert and go to that step on both success and failure.

You can also call your step step 2
Create step 1 as a failure alert step
Create step 3 as a success alert step
Start the job at step 2 and goto step 1 on failure, step 3 on success.
Step 1 and step 3 can call an SP to send the alert.|||thank you for the reply. Appreciate your responses and help in this forum.
Yes, I have made a custom error message/code and an custom alert for that error code.
And all i do is raiserror with the custom error code passed as parameter in the job step. this is captured by the alert and the net send is generated. By the way how do i send an alert from an SP?:confused:

agrument tuncated in execution plan .. how do I get the whole argu

Hello,
I tried analysing a query using the execution plan provided by the query
analyser. But when I move the mouse pointer onto some queryitems it seems
that the argument used by the query part is tuncated. Even using SET
SHOWPLAN_TEXT or SET SHOWPLAN_ALL doesn't help to view the whole argument.
How can I do that ?
Thanks
Lars
In QA by default a column can show text up to 255 characters. I think you
need to increase the this to a higher number.
Go to tools->Options->Results->"Maximum Characters Per row" change the
value to a higher no.
Thanks
Vikas