Job_optimization.sql script

Job_optimization.sql script
Prev	Chapter 32. How to improve system performance	Next

> > >

Job_optimization.sql script

The Job_optimization.sql script is used to create a job that will be regularly executed on the SQL server. When executed, this task reindexes the database and then shrinks it.

Before you launch the script, you need to edit the following in its text:

Replace the 'Tillypad' database with the name of the real database.
```
select @name_db='Tillypad'
```
Set the required launch time in the HHMMSS format.
```
@active_start_time=230000
```

After you initiate the script, the job will automatically start every day at the specified time.