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 |