+ Start a Discussion
sfdcrajsfdcraj 

Global table in salesforce

Hi,

I am using DB amp app in my org. This brings all salesforce tables to SQL server database instance. Now I have a stored procedure which fetches account data from salesforce tables based on flag criteria and inserts them in another SQL database in SQL server. The stored procedure is scheduled.

Now, is there any global table in salesforce in which a field can be set 'Yes' through a button click on my visualforce page so that the scheduled SQL stored procedure can access this global setting and runs the code to insert account data which is flagged into another application database in SQL server instance.

Please guide me if you have information.

Thanks,
raj
EnreecoEnreeco
Have you evaulated using Custom Settings?
https://help.salesforce.com/apex/HTViewHelpDoc?id=cs_about.htm

They can be used as configuration settings that you can use across users to handle logic.

--
My the Force.com be with you