+ Start a Discussion

Global table in salesforce


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.

Have you evaulated using Custom Settings?

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

My the Force.com be with you