I am a new bie to SQL server 2005.
Below is my requirement:
Need to backup all the records in particular table every month, schedule this job and send a notification as and when the job gets executed.
For which I've done the following:
>>Right Clicked MyDB instance> Tasks>Export data
// provided the destination table source tables, pacakage name to save this on File System.
>>Then I moved to SQL Server Agent and created a recurring job under Jobs Folder. Note that I've not added any alerts or notifications.
>> Now when the time to execute this job comes, the following error is thrown
 The Messenger service has not been started - NetSend notifications will not be sent
>>Not sure why I am seeing this. After seeing other forums. I enabled the windows Messenger service. And I dont see any Notification Services created.
>> Note that When I ran the table export for the first time, the data got transmitted.
Not sure if I am following the correct process. Kindly advise with correct steps and help me in understanding the Notification part.
Thanks a lot!!