If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Analyst Macro and the Scheduled user account

Started by Dev1975, 30 Oct 2013 10:16:13 AM

Previous topic - Next topic

Dev1975

Hello,

We have a macro placed in our environment that runs against an ODBC connection to SQL Server and queries some tables against the database. When running manually, there are no problems, the macro runs smoothly. When setting it to run on a schedule against a particular user domain account, it errors with the following message:

"Invalid object name '[database]..
." (note the two dots between database and table).

The default schema for the interactive user is "[database]", however the scheduled user default schema is "[dbo]".

Is there a way of forcing the scheduled user to use the former schema rather than "[dbo]", without having to go into SQL Server and assigning the schema to it? Is there a statement that can be added to the actual macro to force it to use a particular schema, irrespective of what user may initiate the macro?

Many thanks![/color]