+ Post New Thread
Results 1 to 5 of 5
Coding Thread, Daily results in Coding and Web Development; Hi All, I have a "i know it can be done" kind of question. In SQL server you can schedule ...
  1. #1
    Geek_of_HeathMount's Avatar
    Join Date
    May 2009
    Location
    Biggleswade
    Posts
    128
    Thank Post
    21
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Daily results

    Hi All,
    I have a "i know it can be done" kind of question. In SQL server you can schedule and run a store procedure and have the results of the store procedure emailed to you. However, I need to achieve the same result in mysql, any ideas how to achieve this?

    Thanks in advance
    Last edited by Geek_of_HeathMount; 18th May 2009 at 03:46 PM.

  2. #2


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,461
    Thank Post
    866
    Thanked 845 Times in 667 Posts
    Rep Power
    195
    How pretty does it need to be?
    If you are on linux, you could pipe the output of mysql into sendmail etc.. and wang that in cron. Bit prettier if you want to delve into perl/DBI/Mail::Send.

    If you are on windows... beats me ;-P

  3. #3

    Join Date
    May 2008
    Location
    Cheshire
    Posts
    288
    Thank Post
    48
    Thanked 27 Times in 24 Posts
    Rep Power
    18
    What version of SQL you using?
    MSSQL, mySQL etc.

    If you're using MSSQL Express, I don't think it has a built in emailing system. The only way I can think of doing it is making a batch file, using the sqlcmd function.

  4. #4
    Geek_of_HeathMount's Avatar
    Join Date
    May 2009
    Location
    Biggleswade
    Posts
    128
    Thank Post
    21
    Thanked 1 Time in 1 Post
    Rep Power
    0
    I'm running the lastest versions of both as they are both new installs.

    After playing with MS SQL linked in server settings, most of last night into the early hours of this morning!!!, i have managed to get the results in to MS SQL. from there I have used database mail to email myself the results

  5. #5


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,461
    Thank Post
    866
    Thanked 845 Times in 667 Posts
    Rep Power
    195
    Nice sledgehammer, enjoy your cracked nuts

SHARE:
+ Post New Thread

Similar Threads

  1. [News] Pakistan Daily tells it how it is
    By Gibbo in forum Jokes/Interweb Things
    Replies: 10
    Last Post: 8th January 2009, 11:14 AM
  2. Today's Daily Dilbert
    By Joanne in forum Jokes/Interweb Things
    Replies: 1
    Last Post: 12th February 2008, 01:49 PM
  3. daily message
    By alonebfg in forum Wireless Networks
    Replies: 5
    Last Post: 23rd November 2006, 09:37 AM
  4. Daily Dilbert
    By Simcfc73 in forum General Chat
    Replies: 5
    Last Post: 3rd July 2006, 11:50 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •