Can anyone tell me if it is possible to schedule the execution of a script file. If I don't include a path for my script file e.g.

EXEC updStats

SQL Server cannot find it. If I include the path, I get an error (Incorrect syntax near '/'). For both tasks, they are of type TSQL.

Any guidance would be greatly appreciated.

Steve Camsell
Development Consultant
Steve.Camsell@Windmill-DBM.Co.Uk