1 / 75

ASE134 Job Scheduler

ASE134 Job Scheduler. Marion Morrison Sr. Software Engineer mmorriso@sybase.com / 303 413-4250 06/12/2003. What is Job Scheduler. ASE Self Management & Tuning Feature. A central component of Sybase’s self-management and resource tuning initiative and architecture

malachi-ashley
Download Presentation

ASE134 Job Scheduler

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ASE134 Job Scheduler Marion MorrisonSr. Software Engineermmorriso@sybase.com / 303 413-425006/12/2003

  2. What is Job Scheduler ASE Self Management & Tuning Feature • A central component of Sybase’s self-management and resource tuning initiative and architecture • Job creation and scheduling feature

  3. Job Scheduler Benefits Reduces Total Cost of Operation • Improved Ease of Use • Replacement for UNIX Cron Jobs • System-wide Server Management • Time-Sensitive Scheduling • Sybase Central • Relief for DBAs • Write jobs in SQL, not OS-dependent scripts • Automated database management tasks • ASE tunes itself • More time for other DBA responsibilities • Complete logging of job results • Sybase Created and Certified Templates

  4. Server ASE Plugin ASE ASE ASE Job Scheduler in Pictures Architecture: High-Level View Job Scheduler Server Target Server ASE JS Agent job info ASE JS Task job id scheduled job info job, schedule, admin data scheduled job info Stored Procedures sybmgmtdb c:\> sp_….

  5. Job Scheduler Pieces Architecture Components • sybmgmtdb • JS Task • JS Agent • Stored procedure interface • ASE plugin interface • Templates

  6. sybmgmtdb Job Scheduler’s Database • New internal database • Used by all Job Scheduler components • Holds definitions of Jobs and Schedules • Stores output from job execution

  7. JS Task Job Scheduler’s Internal Monitor • Part of ASE internals • Controls JS Agent • Determines which jobs need to run and when • Passes job execution requests to JS Agent

  8. JS Agent Job Control Engine • External Open Client process • Responds to Job execution requests from JS Task • Retrieves Job information from sybmgmtdb • Executes Job against the target ASE • Stores Job status and output in sybmgmtdb

  9. Job Scheduler Interfaces Stored Procedures • Job Scheduler provides a collection of stored procedures for command-line management • Job and schedule management stored procedures have restricted permissions • Job results are accessible by the job owner and administrators

  10. Job Scheduler Interfaces ASE Plugin • New Windows for Job Scheduler Management in ASE Plugin • Scheduled Jobs • Jobs • Schedules • Scheduling Jobs • Scheduled Jobs • Job History • Job Logs • Administration

  11. Scheduled Jobs Finding JS in ASE

  12. Jobs Add Job Wizard

  13. Jobs Giving the Job a Name

  14. Jobs Job Description

  15. Jobs SQL

  16. Jobs Options

  17. Jobs Timeout

  18. Jobs Summary

  19. Jobs New Job Added to List

  20. Schedules Add Schedule Wizard

  21. Schedules Give the Schedule a Name

  22. Schedules Provide a Description

  23. Schedules Set Start Time

  24. Schedules Set Start Date

  25. Schedules Set End Date

  26. Schedules Set Recurrence

  27. Schedules Summary

  28. Schedules New Schedule Added to List

  29. Scheduling A Job East Meets West

  30. Scheduling A Job Confirmation of Job

  31. Scheduling A Job Choose a Schedule

  32. Scheduling A Job Choose a Server

  33. Scheduling A Job Set Options for Scheduled Job

  34. Scheduling A Job Set More Options for the Scheduled Job

  35. Scheduling A Job Scheduled Job Summary

  36. Scheduling A Job New Scheduled Job in List

  37. Run Now Running a Job Outside Its Schedule

  38. Job History Scheduled Job Status

  39. Logging Job Output

  40. Stopping a Job Terminating or Disabling a Job

  41. JS Administration Managing Job Scheduler • Need js_admin_role • Configure JS Task • Configure sybmgmtdb

  42. JS Administration Scheduled Job Context Menu

  43. JS Administration Task Configuration

  44. JS Administration Database Configuration

  45. Demo Job Scheduler in Action • Create the Job • Create the Schedule • Schedule the Job • Run the Job • Review the Job History and Output

  46. Job Scheduler Templates Shortcut for Creating Jobs • Basis for Creating Jobs • Routine Jobs run on multiple databases and on multiple servers • Write once, run as often as needed, wherever needed • Provided by Sybase with Job Scheduler • Data back-up • Statistics management • Reorg • Reconfiguration

  47. Templates & Jobs Creating a Job from a Template • Add Job • Select Template “Browse” button • Select template • Input values for job parameters • Job SQL is written to the Job Definition text box • Add your own SQL if you want • Continue on as you would for any Job created from scratch

  48. Add Job Wizard Start Job as Usual

  49. Job Template Wizard Select Template Category

  50. Job Template Wizard Select Template

More Related