Good morning. I am trying to create a tsql job to run nightly and I am receiving error 208. When I run the sql statement through query, it runs fine, however when I try to put it into the job wizard and parse it, I receive error 208 invalid object. I have checked and the owner for the object is dbo.
Note: When I put in a select statement from that table it works, but my statement is an insert statement and that is when I get the error.
I am not trying to create a table. I am trying to insert into a table. I have tried dbname.dbo.table and that doesn't work either. Here is my code.
insert into familypwd ("family number", "pedalyear") select distinct "family number", "pedalyear" from familylink where "family number" >= 1 and "family number" not in (select "family number" from [familypwd]);
insert into familypwd ([family number], pedalyear)
select distinct [family number], pedalyear
where [family number] >= 1
and [family number] not in (select [family number] from familypwd)