A very simple and interesting database problem

If it's sql server:

Use the job function of SQL.

Manage SQL Server jobs from Enterprise Manager -> SQL Server Groups > Local (Window NT) > Jobs.

1.Right-click to create a job.

2. New Job Properties (General) - > Name [Customize the Name of this Job] - > Tick - > in the enabled box

The classification can be selected or available, and the default [Uncategorized (Local)] - Owner defaults to logging in to SQL Server [Other logins can also be selected]->

Description [fill in the detailed description of this work];

Steps to create a job classification:

SQL Server ** - > Jobs - > right-click all tasks - >Add, Modify, Delete].

3. Create Job Properties (Steps) > Create > Step Name [Custom First Step Name] - > Type [Transact-SQL (tsql) Script] - >

Database [database to operate] - > command.

If it is a simple SQL written directly into it, you can also use the open button to enter a written *sql file.

If you want to execute a stored procedure, fill in the field.

exec p_procedure_name v_parameter1,[ v_parameter2…v_parametern]

Are you sure. If there are multiple steps, you can call the new button below again; It is also possible to insert, delete, or delete existing multiple steps);

4. Create job properties (scheduling) -> create a new schedule> name [custom scheduling name]-> is a checkmark in the enabled box - > scheduling - > recurrence - >

Change [Scheduling Schedule] - > OK.

If you just save this job, don't do it regularly, you can remove the tick in the enabled box);

5. Create job properties (notification) - > use the default notification method [when the job fails, write to the windows application system log] - OK.

Mistake. 5.Mistake. 6.That's right.

Outside mode. -Mode, mode-within mode.

Data structuring, (

Data Sharing. High sex

Redundancy. low, easy to expand).

Relational model, object-oriented model.

12.Data security protection, data integrity protection.

Entity integrity, referential integrity.

16.Outside the pattern, pattern.