Creating and managing jobs

With Data Studio web console job manager, you can create and manage your database jobs from the web console.

You create and manage your jobs by using the following tabs of the Job Manager page:

Job List
From this tab, you can create jobs for your databases or run existing jobs directly against a database without scheduling.
When you create a job or open an existing job, the job details open in the job editor. Use the tabs in the job editor to move between jobs, or use the job section view selector to drill down into the script, schedule, notification, and chain component of each job.
Tip: If you have configured your Data Studio full client to connect to Data Studio web console you can create jobs directly from the SQL script editor.
Schedules
From this tab, you can create and manage schedules for the jobs that you created for your databases.
A schedule defines when a job will be run, whether the job is repeating, and whether the schedule is limited in number of runs or in time. The schedule also defines one or more databases on which to run the job.
Notifications
Use this tab to manage email notifications for the execution of the jobs that you created for your databases.
Job manager notifications help you monitor the execution results for your jobs across multiple databases and schedules without requiring access to the web console.
Each job can have any number of notifications configured, and each notification can be set up with different conditions, a different set of users to notify, and different collections of databases to monitor.
History
On this tab, you can view the status of jobs that ran on your databases. The job history is displayed for jobs that ran according to a schedule in addition to jobs that you ran manually over the last few days.
Tip: If you configured your Data Studio full client to connect to Data Studio web console, you can view job history for a database directly from the Administration Explorer.

Feedback