There are several different ways to schedule it within SQL Server, but they all require SA permissions.

Since you don't have those permissions, follow these steps:

1. Create a new DTS PAckage
2. Add a SQL connection object to the package and set it to your database.
3. Add an Execute SQL Task to your package that executes the procedure: exec DeleteImages
4. Save the package on the SQL Server (remember the name).
5. Open Windows Tash Scheduler.
6. Schedule DTSRun.exe to run the package daily.
7. View the properties of the scheduled task.
8. You will need to manually add the following arguments to the dtsrun execute line:

a. /S: The SQL Server name
b. /N: The name of the DTS Package
c. /E or /U and /P:SQL Server Login credentials (username and password if using a SQL Server account or the trusted connection flag if using your windows account)

The execute line would look something like this if using your Windows account:

"C:\Program Files\Microsoft SQL Server\MSSQL\bin\dtsrun.exe" /S ServerName /N "DTS Package Name" /E

If using a SQL Server account:

"C:\Program Files\Microsoft SQL Server\MSSQL\bin\dtsrun.exe" /S ServerName /N "DTS Package Name" /U MyUserName /P MyPassword


For more info on scheduling DTSRun.exe: http://msdn.microsoft.com=/library/e...tsrun_95kp.asp

For more info on scheduling within SQL Server: http://msdn.microsoft.com/library/en...kgmng_4hm6.asp