bibi92
asked on
Incorrect syntax near ')'.
Hello,
I try to compare the jobs between two servers :
DECLARE @server varchar(30);
DECLARE @Text nvarchar(max);
set @server = 'TESTSRV'
SET @Text= N'IF EXISTS (select * from sysjobs where name not in (select name from ['+ @server + '].msdb.dbo.sysjobs))'
EXEC (@Text)
BEGIN
RAISERROR('count, level 11', 11, 1)
END
Msg 102, Level 15, State 1, Line 1
Msg 50000, Level 11, State 1, Line 11
count_jobs, level 11
How can I resolve it?
Thanks
I try to compare the jobs between two servers :
DECLARE @server varchar(30);
DECLARE @Text nvarchar(max);
set @server = 'TESTSRV'
SET @Text= N'IF EXISTS (select * from sysjobs where name not in (select name from ['+ @server + '].msdb.dbo.sysjobs))'
EXEC (@Text)
BEGIN
RAISERROR('count, level 11', 11, 1)
END
Msg 102, Level 15, State 1, Line 1
Msg 50000, Level 11, State 1, Line 11
count_jobs, level 11
How can I resolve it?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a lot regards
Open in new window