Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

2. The first tab in the Create Scheduled Task Dialog is the General Tab. In this section, specify the Database Connection. The first option is to specify a connection, a database, and a Schema where the scheduled task will be run. Next, specify a Name for the task, by default the name is schedule_number, this can be changed to any name you want that contains only ASCII characters. Now, select the Interval for the task, select from the drop-down menu the interval you want (Once, Daily, Weekly, Monthly). Then choose the start date and time in the drop-down calendar menu. If the interval you chose is Daily, Weekly, or Monthly you have to choose the repetition frequency of the task. When the interval is Weekly or Monthly the Advanced menu pops up. Once you chose the Advanced Task Settings, next is the Run as credentials option. Click Next to select the Query Tab.

...

5. The Status Tab schedules the task, the bar at the top shows the progress in the scheduling, when it finishes the status is displayed as well as the elapsed time. The log shows the procedure for scheduling the task and status. Click Close to leave the Create Scheduled Task Dialog. Find the scheduled tasks in theManage Scheduled Tasks window.

Create Scheduled Task Status.png

Anchor
Advanced
Advanced
Advanced Menu

Inside the General Tab in the Create Scheduled Tasks Dialog when the interval is chosen the advanced menu is available when the interval is Daily, Weekly, or Monthly.

...

When the monthly interval is chosen, the advanced menu pops up as well, here you can choose a date for the scheduled task to expire and also the months and the specific day of the month the task will be run.

Monthly Advanced.png

Anchor
Credentials
Credentials
Run as credentials

Inside the Run As option in the General Tab click on the Credentials button. Aqua Data Studio displays a window where you should type in your Login Name, the Password, and Confirm it.

...