Automating routine tasks with scripts

Use Automator scripts to automate routine database maintenance tasks, referred to as events, that are often time consuming and resource intensive. You can set up scripts to execute automatically in the background or during nonpeak periods such as overnight or on weekends. A script is one or more events, directed at one or more target databases.

Automating database maintenance tasks:

  • Lets you choose the most expedient times, making you less dependent upon the allocation of system resources.
  • Helps you trace problems when they occur because scripted events are always performed the same way and in the same order.
  • Reduces competition for resources within an organization.
  • Lets you schedule routine tasks overnight so graphs are available when you arrive at work the next day.
  • Lets you set defaults for events and databases to help define and maintain organizational standards.

Every time you access an Automator event through its associated icon or through the Automator menu, you are building a script. You can save the script to run with the Scheduler component of Manager, Microsoft Windows Schedule service, or your own scheduling tool. You can also choose Run > Script Now to execute the script immediately.

Automator comes with default scripts with a .b1a extension. Their names reflect their function (for example, demo, daily reports , and so on).

  • Daily ( daily.b1a)
  • Weekly (weekly.b1a)
  • Monthly ( monthly.b1a)

These default scripts include the tasks that you should run as specified by BMC Software. You can use them as is or as the basis for customized scripts.

We recommend you run the database maintenance tasks interactively until you understand each event and its impact on the database. As your database and product knowledge grow, automate the tasks incrementally, testing each event as you go.

Using


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*