Database Profiles

I am running a stored procedure in MSSQL 2000 which cycles through multiple databases. Is there a way to schedule this in 24x7? I am using v3.4.20. I am hitting the limitation of the database profile only allowing a single database.

Thanks.

Jason

You can change databases on the fly using standard MSSQL "USE [db name]" SQL command.

Example:
DatabaseExecute "USE db_name1", rows
DatabaseExecute "my_proc @param1, @param2....", rows
DatabaseExecute "USE db_name2", rows
DatabaseExecute "my_proc @param1, @param2....", rows
DatabaseExecute "USE db_name3", rows
DatabaseExecute "my_proc @param1, @param2....", rows
....
DatabaseExecute "USE db_nameN", rows
DatabaseExecute "my_proc @param1, @param2....", rows

This thing can be surelly done in a loop.

: I am running a stored procedure in MSSQL 2000 which cycles through multiple
: databases. Is there a way to schedule this in 24x7? I am using v3.4.20. I
: am hitting the limitation of the database profile only allowing a single
: database.

: Thanks.

: Jason