Hi
I have set a scheduled task to run but it keeps complaining the code is incorrect and does not run.
If I run the code in in a query window it runs fine. Could someone advise how the code should be so it runs in a job.
UPDATE "148-SalesAnalysisReportData" SET ManualDescription = ProductDescription where ManualDescription is null
go
It is set tot he correct database and is using the SA log in.
Thanks
I have set a scheduled task to run but it keeps complaining the code is incorrect and does not run.
If I run the code in in a query window it runs fine. Could someone advise how the code should be so it runs in a job.
UPDATE "148-SalesAnalysisReportData" SET ManualDescription = ProductDescription where ManualDescription is null
go
It is set tot he correct database and is using the SA log in.
Thanks