-
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
-
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
