Re: Is it possible to set a scheduled job for executing a store procedure?
From: David Gugick (davidg-nospam_at_imceda.com)
Date: 10/30/04
- Next message: David Gugick: "Re: Synchronization Stored Procedure using SQL2K"
- Previous message: Nazeer Oasis: "RE: record delete using a join"
- In reply to: RC: "Is it possible to set a scheduled job for executing a store procedure?"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 30 Oct 2004 01:18:26 -0400
RC wrote:
> And after the transcation is completed, sent a email alert to user....
>
> Thanks
Yes, you can scedule a job to execute a stored procedure and send a
confirmation email to a user on success / failure / or either. You'll
need to have the SQL Agent started and you need to configure the server
with Outlook or some smtp service if I'm not mistaken. You can add the
operator (email recipient) using sp_add_operator and create the job in
SQL Enterprise Manager.
-- David Gugick Imceda Software www.imceda.com
- Next message: David Gugick: "Re: Synchronization Stored Procedure using SQL2K"
- Previous message: Nazeer Oasis: "RE: record delete using a join"
- In reply to: RC: "Is it possible to set a scheduled job for executing a store procedure?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
