Use the Web Assistant Wizard to execute jobs either one time or as a regularly scheduled Microsoft® SQL Server™ task.
The Scheduling screen offers these options.
| Option | Description | Arguments |
|---|---|---|
| Only one time | Immediate, one-time execution. | None |
| On demand | Creates a query that can be executed when needed. | None |
| Only one time at: | Scheduled, one-time execution. | Date, time |
| When the SQL Server data changes | Automatic, triggered execution, displays Alter Trigger dialog box. | Table(s), column(s) from expandable list |
| At regularly scheduled intervals | Scheduled execution. | Every n hours, days, or weeks |
| Generate a Web page when the wizard is completed | Executes a sample Web page for review immediately. | Not available for the Only one time at: option |