Scheduling Jobs

Scheduling Database Jobs

Master Login

Jobs Management allows you adjust the schedule for database jobs. By giving you the ability to control job schedules, Spector 360 lets you control your server performance.

If you do not collect and report on ALL events, you can reduce the load on the server by processing the type of events you DO collect more frequently and those you don't less frequently. For example, if you Web Site usage data, but not Keyword Alerts, you can increase Process DV - URL processing and push off Process DV - Keyword Data processing.

If you have time-critical reporting needs — for example, you need a report on Network Activity by 4 PM daily — you can schedule the Process DV - Network Activity job to run just before report time.

If you have a high-volume site, you can balance database request volume with Data Vault processing and database maintenance.

Simply select the job you wish to schedule and click the Edit Schedule button on the toolbar or right-click and select Edit Schedule.

Backup Jobs
Be aware that backups can take a significant amount of space. Be sure to adjust the Full Backup and Differential Backup job schedules, change the Backup Location, and implement Space Management as needed to avoid overtaxing your resources or storage space.

Archive/Restore Jobs
Although you cannot schedule Archive/Restore jobs directly from Jobs Management, the DB Space Management job can include automatic archives, depending on settings in Space Management.

To set a job schedule:

Choose frequency at which the job Occurs (Daily, Weekly, Monthly).

Choose a Start Time

Select an explicit Daily/Weekly/Monthly or "Once" schedule. See the tables below for more explanation.

For any of the Process DV jobs, you can apply this schedule to one or more OTHER Process DV jobs. Select (mark) the jobs you want to run under this schedule.

Click OK to set the new schedule.

Make sure you do not schedule more than one database job to run at the same time.

The "Occurs" field selection changes the Schedule options shown in the lower portion of the dialog box. The following tables show Daily, Weekly, Monthly, and Once options.

Daily:

The job will execute every day.

Start Time:

The job will start at the selected time (hh:mm:ss AM/PM)

Daily Schedule:

Every 1 day(s) - Runs every day
Every 2 day(s) - Runs every other day
Every n day(s) - Runs every n days (select a number)

Daily Frequency:

Occurs once: The job runs once a day at the start time.
Occurs every n Minutes or Hours: The job runs periodically throughout the day.

Default Schedules:

Process Data Vault jobs run every day, every 2 or 5 Minutes.
The Maintenance - Server job runs once a day at 4 AM.
The Maintenance - Data Retention job runs once a day at 10 PM (depends on Space Management)
The Maintenance - Flush Search Cache job runs every day, every 4 hours.

Weekly:

The job will execute every week.

Start Time:

The job will start at the selected time (hh:mm:ss AM/PM)

Weekly Schedule:

Every 1 week(s) - Runs once a week
Every 2 week(s) - Runs every other week
Every n week(s) - Runs every n weeks (select a number)

Runs on:

Select one day (Mon-Sun) to run once a week.
Select 2 or more days to run several times a week.

Default Schedules:

The Maintenance - Database job runs every week on Sunday at 9 PM.
The Backup - Full job runs every week on Sunday at 11 PM.
The Backup - Differential job runs every week, every day of the week except Sunday, at 11 PM.

Monthly:

The Job will execute every month.

Start Time:

Job will start at the selected time (hh:mm:ss AM/PM)

Monthly Schedule:

Day: Run the job on day (1-31) of the month. For example, select 1 to run on the first day of each month. Select 15 to run the job on the fifteenth of each month.

The nth Day of the month:

Choose first/second/third/fourth or last, and then
choose Sunday-Saturday/Weekday/Weekend Day.
For example, run the job the second Sunday of every month.
Run the job the third Wednesday of every month.
Or, run the job the last Weekend Day of the month.

Default Schedules:

The Maintenance - Space Management job runs once a month, first day of the month at midnight (depends on Space Management)

Scheduling Database Jobs

Related Topics