Toad World® Forums

Query is processing in Editor but not within Scheduled Job (.tas)


#1

I have created a new connection to MS SQL server (Toad 4.1.) due to an upgrade. I can run existing queries within Editor. But when I update connection in the existing .tas the query does not recognize the tables within structure of the db. I have never encountered this issue before. Please assist.


#2

Does the sql in the automation file fully qualified? IE select col from database.owner.table;

The editor allows you to point to a database and not fully qualify the sql. The automation activity will use the default database of the connection if the sql is unqualified.


#3

It seemed to do the trick! thank you Debbie. You are awesome


#4

[Y]


#5

I call her the automation goddess but awesome is a good description too.