Mar 13, 2001 #1 KevinFSI Programmer Nov 17, 2000 582 US Is there a way to schedule SQL Server to create a flat file of data, and e-mail it to an individual on a recurring basis? Kevin slanek@ssd.fsi.com
Is there a way to schedule SQL Server to create a flat file of data, and e-mail it to an individual on a recurring basis? Kevin slanek@ssd.fsi.com
Mar 13, 2001 1 #2 foxdev Programmer Feb 11, 2000 1,995 US Yes. Create and save a DTS job to do the extracting, and use XP_SENDMAIL to do the e-mailing. Robert Bradley http://www.foxdev.com/Got extra money lying around? Visit: http://www.agrainofhope.org Upvote 0 Downvote
Yes. Create and save a DTS job to do the extracting, and use XP_SENDMAIL to do the e-mailing. Robert Bradley http://www.foxdev.com/Got extra money lying around? Visit: http://www.agrainofhope.org
Mar 13, 2001 Thread starter #3 KevinFSI Programmer Nov 17, 2000 582 US Thanks a million. Much appreciated! Kevin slanek@ssd.fsi.com Upvote 0 Downvote