USE msdb
GO

EXEC sp_delete_job @job_name = 'Ranking resetsWeek'
GO

EXEC sp_delete_job @job_name = 'Premiando_Semanal'
GO

USE msdb
GO

BEGIN TRANSACTION

DECLARE @jobId BINARY(16)

EXEC msdb.dbo.sp_add_job 
@job_name = 'Premiando_Semanal',
@enabled = 1,
@owner_login_name = 'sa',
@job_id = @jobId OUTPUT

EXEC msdb.dbo.sp_add_jobstep 
@job_id = @jobId,
@step_name = 'Step01',
@subsystem = 'TSQL',
@command = '
declare @AccountID varchar(10)

Select top 1 @AccountID=AccountID from character order by ResetsWeek desc
Update memb_info set gold=gold+50 where memb___id=@AccountID

Select top 1 @AccountID=AccountID from character order by ResetsWeek desc
Update memb_info set gold=gold+30 where memb___id=@AccountID

Select top 1 @AccountID=AccountID from character order by ResetsWeek desc
Update memb_info set gold=gold+20 where memb___id=@AccountID

Update character set ResetsWeek=0
',
@database_name = 'MuOnline'

EXEC msdb.dbo.sp_add_jobserver 
@job_id = @jobId

COMMIT TRANSACTION