|
Home > Archive > MS SQL Server MSEQ > July 2005 > Execute StoreProcedue in SQL2000 every time i received a replay me
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 |
Execute StoreProcedue in SQL2000 every time i received a replay me
|
|
| Renato Ribeiro 2005-07-26, 9:24 am |
| Hi,
how can i execute a StoreProcedue in SQL2000 every time i received a replay
message with a specific subject, and pass some arguments like the subject.
thank in advanced,
Renato Ribeiro
| |
| Hari Prasad 2005-07-26, 8:24 pm |
| Hi,
1. Create a Task to execute stored procedure
2. Create a message (SP_ADDMESSAGE) to create the subject
3. Using the message ID and Task name create a alert using SP_ADDALERT
4. Trigger the message using RAISERROR statement.
This will automatically fire the Task to execute the stored procedure
Thanks
Hari
SQL Server MVP
"Renato Ribeiro" < RenatoRibeiro@discus
sions.microsoft.com> wrote in message
news:FA8C6A92-CB30-46B1-A9B8- 187F43927B4D@microso
ft.com...
> Hi,
> how can i execute a StoreProcedue in SQL2000 every time i received a
> replay
> message with a specific subject, and pass some arguments like the subject.
>
>
> thank in advanced,
>
> Renato Ribeiro
>
|
|
|
|
|