Freaking Out Job!!!
Jan 28, 2004
i have created a sql server job that i have scheduled to run every 10 min. in this job i have diferent steps wich seem to be working fine i also have 2 alerts that i have created for this job in case some steps fails so that i can be notififed via email with specific messages. the Weird thing is this job keeps re executing over and over again and never whaits for that 10 min delay and of course i get flooded with emails since i have set up test data to get these messages on purpose. so y doesnt wait 10 min like i have scheduled .PLZ HELP...
View 14 Replies
Aug 15, 2005
I'm dealing with a database with tables that have freaking columns.Partial DDL:Create table [tbl IMN] ([Ave Cost-Mn] varchar(10))-- yeah, this column contains string valueNow, I'd like to rename all these freaking columns without specialcharaters like '-', 'whitespace' etc systematically (meaning loopthrough all tables and columns dynamically). It seems that thesp_rename proc can't handle some function call or ...?e.g.exec sp_rename '[tbl-IMN].[Ave Cost-Mn]',replace('[AveCost-Mn]','-',''),'COLUMN'better if it can work,exec sp_rename '[tbl-IMN].[Ave Cost-Mn]',replace('[Ave Cost-Mn]','-|',''),'COLUMN'TIA
View 6 Replies
View Related
