Scheduling a SQL script from the server

[hlabonte]

I have a script in a hosted database which imports records via a SQL server call. I'd like to schedule this to run in the evenings from the server, but the script fails with an error 643 "unsupported script step".

Can anyone help me in how to schedule this type of a script on the server?

[Steven H. Blackwell]

It says "unsupported" and that's what it means. The Server cannot do imports. Try running the script from a workstation.

Steven

[hlabonte]

Ugh, those are the type of scripts I need to run from the server. Grr. One step forward, two steps back. :violin: