Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 passing variable for database name in job triggered by alert

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-23 : 21:02:13
Cathy writes "I want to set up an alert to monitor transaction log space and fire a scheduled task to dump log with no_log. I want this job to pass the database name as using a variable rather than a hardcoated database name so that I can use a single (1) error message, a single SQL task for ANY of the databases on the server...I would hate to duplicate error messages and tasks for each database. Any ideas?"
   

- Advertisement -