Two things,

1) Check the "Delay between reposnses..." option on the "Response" tab of the Alert properties dialog. It may be the response delay that is preventing the job from being run.

2)...

Alex

Are you able to create a llinked server to the production database? If so, you can simplify you DTS package to a series of delete/update/insert procedures for each table.

eg:

INSERT...

To get an idea of the numbers possible given an appropriate setup, take a look at the results posted at http://www.tpc.org

The current price/performance leader is a SQL Server 2005...

"This way we can keep the records of the user initiated backups and restores in a different "administrative" database and offer users some sort of version control for their...

Truncate table won't work if there are Foreign Keys defined.

Your best option would be to build your own aspx page.

You can retrieve a list of parameters for a report via the web service. Take a look at the GetReportParameters method. One...

Your call, live with the "smiley" delay, or just go plain text. Myself I couldn't live without the smilies

Hmmm ... I've never had to change my code yet 

My routine creates a unique filename that includes database name, backup type and datetime. Database is...

kwaan, just a tip for the future. Folks around here a pretty adept at detecting homework assigments and generally leave them alone. Giving...

If you want to get rid of the "smiley" delay, there is an option on your profile,

"Disable WYISWYG Forum Editor (faster page display)"

Running the package against a different server/database has nothing to do with the startup parameters. These are used for determining the location of the package.

To run the package against a...

I'm presuming you have stored procedures in one database that reference data in another database. There is really no way to avoid some editing when the database name changes. You...

This is very simple, check Books Online.  Under the "Backing Up and Restoring Databases" topic there is a section headed "Managing Backups" which details how to verify a backup.

Take a look in the script library,

http://www.sqlservercentral.com/Scripts/

There are a number of scripts that provide backup functionality, pick one that suits your needs the best.

" ... But sometimes in the future, it may become full. So need to shrink/truncate it, right?  ... "

As per my previous post, "Unless you're experiencing a large amount of...