• Interesting. I guess the first thing is to figure out why the job is suspended? If you run as SA does it work? Possibly the snapshot job is still being created or is in progress when you try to run? Dont see much in BOL about why something is suspended.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/