How to specify an alternative scheduler or data source for EJB timer service in Change Management Server

Answer

Follow the steps below to create a new scheduler service associated with an Oracle database and assign it to EJB timer service:

1. Create an Oracle user account and make sure that the user has "connect" and "resource" privileges.
   
   Note: If you have an existing Oracle account with proper privileges, you don't need to create a new account.
   
   
2. Start CM Server.
   
   
3. Open WebSphere Application Server Administrative Console and log on the following url with a blank user name: "http://localhost:12060/ibm/console"
   
   For more details, refer to WebSphere Application Server Information Center.
   
   
4. Create a new JDBC provider.
   
• Go to Resources > JDBC > JDBC Providers
  
• Choose scope as "Node=dfltnode, Server=server1"
  
• Click New
  
• Select database type as Oracle
  
• Keep provider type as Oracle JDBC Driver
  
• Select implementation type as connection pool data source
  
• Specify a name for the provider
  
• Click Next
  
• Specify the directory location for ojdbc14.jar
  
• Click Next
  
• Review the summary and click Finish
  
• Click Save to save the changes
  
  For more details, refer to WebSphere Application Server Information Center.
  
  
5. Create a new data source.
   
• Go to Resources > JDBC > Data Sources
  
• Choose scope as Node=dfltnode, Server=server1
  
• Click New
  
• Specify a data source name, for example: mydatasource
  
• Specify a JNDI name for the data source, for example: jdbc/mydatasource
  
• Click Next
  
• Select the JDBC provider that you just created
  
• Click Next
  
• Specify the URL for the database connection, for example: jdbc:oracle:thin:@localhost:1521:orcl
  
• Click Next
  
• Review the summary and click Finish
  
• Click Save to save the changes
  
  For more details, refer to WebSphere Application Server Information Center.
  
  
6. Specify log on information for the data source.
   
• Go to Resources > JDBC > Data Sources
  
• Open the data source that you just created
  
• Open JAAS - J2C authentication data under Related Items
  
• Click New
  
• Specify an alias along with the user name and password for the user account that you created in Step 1
  
• Click OK
  
• Click Save to save the changes
  
• Open the data source again
  
• Choose the JAAS alias that you just created for Component-managed authentication alias
  
• Click OK
  
• Click Save to save the changes
  
• (Optional) you can then test the connection of the data source in the data source list
  
  
7. Create a new scheduler.
   
• Go to Resources > Schedulers
  
• Choose scope as Node=dfltnode, Server=server1
  
• Click New
  
• Specify a name for the scheduler, for example: myscheduler
  
• Specify a JNDI name for the scheduler, for example: jdbc/myscheduler
  
• Select the data source you just created
  
• Specify the table prefix for the scheduler tables, for example: ejbts_
  Notice that the pre-configured EJB timer service uses EJBTIMER_ as the prefix.
  
• Select the default work manager wm/default
  
• Click OK
  
• Click Save to save the changes
  
  For more details, refer to WebSphere Application Server Information Center.
  
  
8. Create tables for the scheduler.
   
• Go to Resources > Schedulers
  
• Select the scheduler that you just created
  
• Click Create tables to finish the task
  
  For more details, refer to WebSphere Application Server Information Center.
  
  
9. Configure the EJB timer service to use the new scheduler.
   
• Go to Application servers > server1 > EJB Container Settings > EJB timer service settings
  
• Check Use custom scheduler instance and select the JNDI name of the scheduler that you just created
  
• Click OK
  
• Click Save to save the changes
  
  For more details, refer to WebSphere Application Server Information Center.