Ủy thác không lên điểm

[kubi.l0v3]

Hi anh em
Mình dùng web NBB bản mới nhất
Trước mình chaỵ 1 con Server, dùng chức năng ủy thác ok.
Giờ mình chuyển con SV khác, mình coppy full từ Sv cũ sang, không thiếu gì.
JOB của NBB mình dã chạy đủ.
Start đã báo Succe... ( thành công )
Nhưng khi mem ủy thác thì lại không lên điểm nào?
Vậy lỗi ở đâu?
Mong anh e chỉ giáo
Xin cảm ơn

[heroviet2301]

Từ từ để mình Test kĩ lại cái query mới của NBB đã, có gì mình gửi cho

[kubi.l0v3]

Up lên đi nào .................................................. ...............

[sontran901]

Đâu có lỗi gì? Ủy thác thì xem Job đã run chưa là đc đó mà. Còn code NBB thì mình vẫn xài ầm ầm mà

[heroviet2301]

Bạn dùng Query Job UyThacOnline và Proc này rồi Test nha, mình đã test và ủy thác ngon

BEGIN TRANSACTION            
  DECLARE @JobID BINARY(16)  
  DECLARE @ReturnCode INT    
  SELECT @ReturnCode = 0     
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[Uncategorized (Local)]') < 1 
  EXECUTE msdb.dbo.sp_add_category @name = N'[Uncategorized (Local)]'

  -- Delete the job with the same name (if it exists)
  SELECT @JobID = job_id     
  FROM   msdb.dbo.sysjobs    
  WHERE (name = N'UyThacOnline')       
  IF (@JobID IS NOT NULL)    
  BEGIN  
  -- Check if the job is a multi-server job  
  IF (EXISTS (SELECT  * 
              FROM    msdb.dbo.sysjobservers 
              WHERE   (job_id = @JobID) AND (server_id <> 0))) 
  BEGIN 
    -- There is, so abort the script 
    RAISERROR (N'Unable to import job ''UyThacOnline'' since there is already a multi-server job with this name.', 16, 1) 
    GOTO QuitWithRollback  
  END 
  ELSE 
    -- Delete the [local] job 
    EXECUTE msdb.dbo.sp_delete_job @job_name = N'UyThacOnline' 
    SELECT @JobID = NULL
  END 

BEGIN 

  -- Add the job
  EXECUTE @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID OUTPUT , @job_name = N'UyThacOnline', @owner_login_name = N'sa', @description = N'No description available.', @category_name = N'[Uncategorized (Local)]', @enabled = 1, @notify_level_email = 0, @notify_level_page = 0, @notify_level_netsend = 0, @notify_level_eventlog = 2, @delete_level= 0
  IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback 

  -- Add the job steps
  EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 1, @step_name = N'Query', @command = N'exec PointUyThac_by_NetBanBe', @database_name = N'MuOnline', @server = N'', @database_user_name = N'', @subsystem = N'TSQL', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2
  IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback 
  EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1 

  IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback 

  -- Add the job schedules
  EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'0h - 9h : 1 minutes', @enabled = 1, @freq_type = 4, @active_start_date = 20110612, @active_start_time = 500, @freq_interval = 1, @freq_subday_type = 4, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 90000
  IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback 
  EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'16h - 20h : 1 minutes', @enabled = 1, @freq_type = 4, @active_start_date = 20110909, @active_start_time = 160500, @freq_interval = 1, @freq_subday_type = 4, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 200000
  IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback 
  EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'21h - 24h', @enabled = 1, @freq_type = 4, @active_start_date = 20110909, @active_start_time = 210500, @freq_interval = 1, @freq_subday_type = 4, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 235959
  IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback 
  EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'10h - 15h : 1 Minutes', @enabled = 1, @freq_type = 4, @active_start_date = 20111002, @active_start_time = 100500, @freq_interval = 1, @freq_subday_type = 4, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 150000
  IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback  

  -- Add the Target Servers
  EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, @server_name = N'(local)' 
  IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback 

END
COMMIT TRANSACTION          
GOTO   EndSave              
QuitWithRollback:
  IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION 
EndSave:

SQL 2000 --> Muonline -->> stored procedures -->>PointUyThac_by_NetBanBe.

CREATE PROCEDURE PointUyThac_by_NetBanBe
As
Begin
Declare
@PointUyThac int,
@SubUyThac varchar(50)
SET @PointUyThac=1                -- So PointUyThac tang
SET @SubUyThac='%-1'		--Ten Sub cho phep Uy Thac

Update Character
SET UyThac = 0
From Character JOIN MEMB_STAT
ON Character.AccountID = MEMB_STAT.memb___id AND (Character.UyThac=1) AND ((MEMB_STAT.ServerName NOT LIKE @SubUyThac) OR (Character.MapNumber!=0 AND Character.MapNumber!=3) OR (Character.MapNumber=0 AND (Character.MapPosX<95 OR Character.MapPosX>175 OR Character.MapPosY<90 OR Character.MapPosY>165)) OR (Character.MapNumber=3 AND (Character.MapPosX<165 OR Character.MapPosX>205 OR Character.MapPosY<85 OR Character.MapPosY>130)) )

UPDATE Character
SET PointUyThac = PointUyThac + @PointUyThac
FROM MEMB_STAT JOIN AccountCharacter ON MEMB_STAT.ConnectStat = 1 and MEMB_STAT.ServerName LIKE @SubUyThac and MEMB_STAT.memb___id = AccountCharacter.Id 
JOIN Character ON AccountCharacter.GameIDC = Character.Name and Character.UyThac = 1

End
GO