June 29, 2009 at 1:08 am
hi,
i have a job to archive the data to another database, its giving following error:
Executed as user: NT AUTHORITY\SYSTEM. Incorrect syntax near 'um_'. [SQLSTATE 42000] (Error 102).
The step failed.,00:00:02,15,102,,,,0
plz help me out this.
🙂
June 29, 2009 at 3:24 am
HI,
Can you post the script of the job?
-Vikas Bindra
June 29, 2009 at 4:00 am
this is the script i have written:
select * into [dblog].[dbo].[um_table]
from [dbprod].[dbo].[um_table]
go
truncate table [dbprod].[dbo].[um_table]
🙂
June 29, 2009 at 4:24 am
I don't see any syntactical problem with the script.
Can you script out the job by right click on the job and selecting "Script job as" and post the script?
-Vikas Bindra
June 29, 2009 at 5:11 am
I Have total 600 tales to archive data, same script for the each and every table in a batch.
will it be affected by version?
my production server configuration
is 9.00.1399.06
Enterprise Evaluation Edition
🙂
June 29, 2009 at 6:54 am
I don't think that version will have an impact...
The query seems fine to me. Can you try parsing the script by copy pasting it in SSMS? and see if there are any error.
-Vikas Bindra
June 29, 2009 at 11:02 pm
hi,
its working fine in query window(manual run), but it is giving the error for job only.
🙂
June 30, 2009 at 4:41 am
That is strange:ermm:
You can try keeping the script in a stored procedure and call the procedure from the job.
-Vikas Bindra
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply