• Since you are planning to run it round the clock, running it through a job is a better option. Running it through SSMS or SQL Agent job will have the same performance impact.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga