- Working method:
Enterprise Manager - Administration - SQL Server Agent - Right-click Job - Enter Job Name in "General" - "Step" - New - New - "Step Name" Enter the step name - "Type" Select "Transact-SQL Script (TSQL)" - "Database" Select the Database of the Execute Command - "Command" Enter the statement you want to perform: Delete from table Where login date
Then start the SQL Agent service and set to automatically start, otherwise your job will not be executed.
Setting method: My Computer - Control Panel - Administrative Tools - Services - Right-Right-Right-Right-Right-Right-Start Type-Select Auto Start-OK.
