--Create Procedure
Create Procedure [dbo].[sp_DelFlag]
As
--Your SQL Script Below
--For Example:Delete From tablename
Update tablename Set delflag=0 where delflag=1
--Add Job
USE msdb
EXEC sp_add_job @job_name = 'Auto Del Flag',
@enabled = 1,
@description = 'This Job Will Auto Del The Flag',
@owner_login_name = 'sa',
@notify_level_eventlog = 0,
@notify_level_email = 0,
@notify_level_netsend = 0,
@notify_level_page = 0,
@delete_level = 1