Post reply

Creating a CHECKDB job- NEED HELP!!!

  • March 24, 2010 at 8:55 am

    #139946

    Hi,

    I'm trying to create a scheduled job that will do a CHECKDB on selected databases and have the output sent to a file or sent as an email.

    Does anyone have any idea how to do this?

    ...thanks

  • March 24, 2010 at 9:02 am

    #1138966

    To output to a file just create a SQL Agent job and then under "Advanced" for your step set the "Output File" to your desired location. Then you can use Database Mail to pick the file up and email it, or use an outside program to.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • March 24, 2010 at 10:23 am

    #1139049

    Thanks this is a great help. I was trying to create an SSIS package to accomplish this. But using the SQL Agent works just as well to create the file.

    I just need to figure out how to work database mail in. Since, I have never used it before.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply