|
-
Dec 3rd, 2000, 08:34 PM
#1
Hi,
In SQL 7.0:
I have a job upon a completion of which a SomeFile.txt file is being created
-with data ( if there were any data processed) or
-without any data ( if no data was processed)
IF SomeFile.txt file with data! was created then I have to send an Email to 2 users with short message.
Any ideas how to do that??? Or what is the best approach to tackle that?
Thanks lot,
andy
-
Dec 4th, 2000, 04:58 AM
#2
Hyperactive Member
Look up SQL mail it's quite effective
Exec Master..xp_sendmail
@Recipients = @Recipients,
@Subject = @Subject,
@Message = @Message,
@Attachments = @Attachments,
@No_Output = 'TRUE'
That's the call to it above
Hope this helps
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|