I had the same problem late last year. The reason why it works in SSMS and not as a job is the two have different default values for the...