i got that fixed by try catch

Thanks , but i have scom to monitor my servers and currently it is monitoring event id 1479 for db mirror time out, are there any other in build event...

perfect , much appreciated!!

thanks but it still gives incorrect syntax at Select @Dbnames = '''+ @DBName+'''

here is the full script to create jobs

Declare @CurrID int,@MaxID int

Declare @dbs Table (DBID int identity(1,...

just to add this is the code after job is created , so if i could assign the db name so it would be Select @Dbnames = 'reporting' not like...

Thanks for reply , this is not the sp , what i am trying to do is to create generic sql script that will create job for each user db...

Try Catch ,@@Error could not able to go to my insert statement when it was not able to connect to remote sql server,it just throw below and sql job fails

OLE...

Thanks!! pretty useful..

pretty cool ,thanks i was missing alert part....

got from one of blog

DECLARE @ts_now bigint = (SELECT cpu_ticks/(cpu_ticks/ms_ticks)FROM sys.dm_os_sys_info);

SELECT TOP(1)

--SQLProcessUtilization AS [SQL Server Process CPU Utilization],

...

Thanks , is there any way i can do this with policy management?

Just to add it is SQL 2K8 SP1 Enterprise Edition.

Just to add ,i tested and columns datatype were replicated fine but getting error for PK column ,is there any way to handle PK column without dropping the article?

thanks , actually i need some concrete link to prove H/W raid performance advantage over S/W but did not find much on internet that really stop to opt my team...

I just checked and i dont find proxy account option from drop down if i choose job type as T-SQL so not sure what is the other way? also can...