You can avoid manually selecting what to include in a job scope by using wildcard patterns. Wildcards enable you to select all objects, databases, or both whose names match the criteria you specify. The wildcards are then evaluated at run time to determine the scope of the job.
- From the Jobs tab, click next to a job and click Edit.
- From the Scope tab, click the option Custom object list and then click Edit list.
From the Wildcards tab, enter a pattern for a database, object, or both in the filter boxes.
If you select only a database pattern, all objects in the databases that meet that criteria become the scope.If you select only an object pattern, all objects that meet that criteria in any database are added to the scope.
Click Add pattern.
The pattern is displayed in the Wildcard patterns pane and is saved for reuse.
- [Optional] Click next to a pattern, and click Delete to delete the wildcard pattern.
- Click OK.