Hi,

I have several SQL Server stored procedures that I have to launch each night on several databases.
I wanted to create some task templates by using variables like "databasename"

EXEC [{USERVAR(databasename)}].[Schema].[Stored_Procedure]

Each Job sets the variable name at the beginning.

Problem : each job is launched at the same moment, so the variable is changed multiple times and SQL jobs are failing.

Do you have an idea on how to solve that please ?

Thanks.

1. Create a text file with all properties tab separated.
2. create a read file Task and read the file
3. Create sql task using loop Variables
4. Add the loop to the sql Task. Check the loop tutorial here: http://www.visualcron.com/Tutorials.aspx 

---