Thank you v much for this really useful info. Jobs concept is new to me. Anyway I came to lknow abt this now.
But at the last step, I want to trigger email to an email id. I could c that the corresponding option is disabed. When I create a new email operator, I coulndt enter other details and I can only enter the name of the email operator. How to connect and proceed further? pls do make me clear
Not sure- I don't use that feature. Sounds like you are using 2000 too - I am on 2005 I am afraid. Personally I log all this stuff to a table rather than use emails, especially for logging successful completion.
You shouldn't need to jump out to a DTS package to send an e-mail on completion. Adding DTS to this mix needlessly complicates it.
You need one of these options:
A) Set up your SQL Server to send/recieve e-mails. I admit I am sketchy on the details of doing this, because is a network issue and not my area of expertise. Get your network admin to help you with it.
B) Install xp_smtp_sendmail, a free utility available at http://sqldev.net/xp/xpsmtp.htm
xp_smtp_sendmail is easy to install and easy to use. It enables you to send e-mail messages from sql code.
If it's not practically useful, then it's practically useless.