tailieunhanh - Oracle Database Administration for Microsoft SQL Server DBAs part 22

Oracle Database Administration for Microsoft SQL Server DBAs part 22 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments | 192 Oracle Database Administration for Microsoft SQL Server DBAs SQL Server Oracle msdb DBMS_SCHEDULER DBMS_JOB SQL Server Agent Job slave processes parameter max_ JOB_SLAVE_PROCESSES History and logs History and logs in dba_scheduler_ views Multistep jobs Jobs inside and outside the database Multistep jobs Jobs inside and outside the database Used for maintenance tasks Used for maintenance tasks Manage in SQL Server Management Studio Permissions Manage in OEM or with DBMS_ SCHEDULER Permissions Create job and Select SQLAgentUserRole in msdb any dictionary TABLE 7-4. Scheduling in SQL Server and Oracle OQACLC rmciptiv Mnnngnr 11 g Database Control MMOfVl SrhcdiA r Mm Create Job__ r 1 loggad n M Sv tMeral .f. . Narr naULCK 8S J n C6Al I Cnsbfed ymOno Dwapiton bu fc rd . far l tt ttCkr. lo jr leeel log job rtrn or r iftlKS j S ec r bwrq rggggrgri I the Kb Job ein CtFAlAT_J0B_CLAS8 Create Job Class AiA Crcp Steer better the wb mx 5 be coced arte. condMxn RMörtabb f Steer a-eee. the wo c n te testered tnerueh or n the evert cr Fabre SnowaOC j Cancel OK Sck-tt tjv command tflw far 9 job. urAr 9 lon-rrcrd ruqururnerib. Command Typa PI sqi Mnrk Change Command Typ pi sa t n cuite enmadwte fer rdo coekretce nd FIGURE 7-9. Creating a job in OEM Chapter 7 Database Maintenance 193 For the command type you have the following options Program name PL SQL enter the code in the text box Stored procedure Executable Chain to create steps and chain the jobs together Set up the schedule for the job on the Schedule tab. The Options tab lets you raise events to handle success failure and other job statuses set limits on runtime and failures set priorities and specify other options. Creating a chain will set up different steps for the job. The programs should be created first. In OEM make sure to enable the jobs that you want to run. After creating the steps you can set up rules for what to do between the steps. The steps also do not .