22 May, 2009
0 Comments
0 categories
If you use the sp_add_jobserver don’t use ‘.’ as servername, use ‘(local)’, else you will get the error: de specified server does not exist
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)’
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
Tags: SQL Server