Thursday, 1 March 2012

How to use session variable in RPD


How to use session variable…..

Session variable: The session variable contains the information of the user who logs in till he logs out...

Two types of session variables System session variables and Non system session variables. 



Create first initialization block

 

 

Select edit data resources
To make values in the tuples as username and password for obi from table
( ex: reservation database bus and routes are tables….to make values of busname and busid as  obi username, password  we should write a query in edit data source place as Select busid from bus where busid=':USER'and busname=':PASSWORD')




Now to set connection pool click BROWSE button


 
Select connection pool and click select button then click ok….
Then now click edit data target



GIVE suitable session variable name(EX:USER)


 
Then click yes …


Then click ok…

Finaly give suitable name for session variable initialization blockand save….(EX: TEST)

 
System session variable list….



Non system session variable list….


 
For this creation follow the same procedure but the order of creation should be same as in the query selection column list…
( Ex: Select  SIEBEL_USER_NAME,POSITION,LOB,ZONE,TERRITORY,FCO,USER_DETAILS,MANAGER,PASSWOR
from EMP_INFO
WHERE SIEBEL_USER_NAME=':USER' AND PASSWORD=':PASSWORD'
Session variable Creation order
1)In the above Siebel username is taken as system session variable for user login
2) create non system session variable ‘POSITION’.
3) create non system session variable ‘LOB’
4) create non system session variable ‘ZONE’
5) create non system session variable ‘TERRITORY’
6) create non system session variable ‘FCO’
7) create non system session variable ‘USER_DETAILS’
8) create non system session variable ‘MANAGER’
9) In the above PASSWORD is taken as system session variable for user login.)

Restart the services

 
Now try login using the values in the table(EX:KSRTC as username 111 as password,
EX:SIEBEL_USER_NAME as user name and PASSWORD as PASSWORD column from EMP_INFO )
 
 
On success

TO make prompt value defaulty to set ,user who as logged in 

1) log in as administrator and generate report

In this select filter for the prompt (ex:BUSNAME)


Give server variable as NQ.SESSION_USER(i.e USER the system session variable which we have created) save and logout
Now login as values in table(EX: busname ksrtc and busid 111)
U will find default values in prompt as logged in user value





Posted by at No comments:

Wednesday, 29 February 2012

BI PUBLISHER


                                                      
1)      To configure for BI publisher follow the configuration method.



   2)      Now open the file C:\OracleBIData\web\config\credentialstore.xml you can see two configuration one for scheduler and another for bipublisher.
3)     Login to obi presentation.
 
                                      
4) select bipublisher form more products.

5)
      
6) Now select one folder form shared folders.



7) From above u need to select Template builder….and select save file option to save that exe file in suitable location.

                                              
8) Now run the file….
          
   
                                               
9) After installation u will find it in start/allprogrammes.

     
10) Now open ur new word document select Add-Ins tab (depends on microsoft word document) u will find OracleBIpubliser as a new option.
  

                    

11) Now select log on and give suitable username password.


 
12) If it succeeds you will get the template.

13) We can create new folder…and new reports using following…

14)  U will find the report which u have created…. select the edit option to add fields…

                 
  
15)  Here u can set report properties …


16) Create new data model.

17) Give suitable name for data set, type and data source whether from database or from existing obiee reports. Finaly select query builder….

 18)

19) select the required  tables and make suitable joins….then check the fields u required.


20) U can add conditions on each single field.

 21) Here u can give suitable name for the selected fields,conditions,sort type whether ascending or descending ,Functions can also be applied like count,sum,avg,count distinct,lower,upper,trim fucntions can be applied,group by can also be applied.


 22) Here you can view the query for the selcted fields and conditions.
 

   23)

     24) The last result tab is to view the results for the query……In drop down 10,50,100 is the number of  rows.    
                           


     25) We can create new layouts for the reports instead of existing one….select new
        

     26)  Give name for template…
      
     27) upload new template with the existing one.
 
     28) To create new template for the same report using the word document with different views.

     29) Now open ur new word document select Add-Ins tab (depends on microsoft word document) u will find OracleBIpubliser as a new option.

       
     30)  Now select log on and give suitable username password.

     31) If it succeeds you will get the template.
      32) Now select the folder where u have saved your created report,after selecting ,in layout templates u will get option to create new word template w.r.t that report.

      33)  To create new template for the report 
     

     34) Select the insert/fields

     35) After adding fields u can preview the results.

       
      36) U can try for different views like pivot view,table wizard,chart view ..
          
        37) After saving the report u should upload template to the existing report .

       38) Using new layout upload new template and save the entire report …finaly view the report and  u can select from the drop down new templates….
 
     39) U can add this template to the dashboard.         

     40) Pick the bi publisher report in the following manner.

        
    41) Final view when we add to dashboard.
      
    42) Scheduler configuration in publisher.
    
      Connection string: jdbc:hyperion:sqlserver://SERVER NAME;DatabaseName=css
                                  Jdbc:heprion:sqlserver:system name;DatabaseName=name of the database.

      
Click install schema .

Alternate way:

If list of table xmlp_..... and qrtz_... tables are not generated in respected database then use the following query to generate tables.

USE [css]                  /********* here u should specify the database name in the css place********/
GO
/****** Object:  Table [dbo].[QRTZ_CALENDARS]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QRTZ_CALENDARS](
                        [CALENDAR_NAME] [varchar](80) NOT NULL,
                        [CALENDAR] [image] NOT NULL,
 CONSTRAINT [PK_QRTZ_CALENDARS] PRIMARY KEY CLUSTERED
(
                        [CALENDAR_NAME] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[QRTZ_BLOB_TRIGGERS]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QRTZ_BLOB_TRIGGERS](
                        [TRIGGER_NAME] [varchar](80) NOT NULL,
                        [TRIGGER_GROUP] [varchar](80) NOT NULL,
                        [BLOB_DATA] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Product]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Product](
                        [PRODKEY] [int] NULL,
                        [PRODDESC] [nvarchar](255) NULL,
                        [LEVELX] [nvarchar](255) NULL,
                        [COLOR] [nvarchar](255) NULL,
                        [FINISH] [nvarchar](255) NULL,
                        [TYPE] [nvarchar](255) NULL,
                        [SIZEX] [int] NULL,
                        [SEQ] [int] NULL,
                        [BRAND] [nvarchar](255) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Period]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Period](
                        [PerKey] [bigint] NULL,
                        [PerDesc] [nvarchar](255) NULL,
                        [Month] [nvarchar](255) NULL,
                        [Year] [int] NULL,
                        [LevelX] [nvarchar](255) NULL,
                        [Period_N] [tinyint] NULL,
                        [Seq] [int] NULL,
                        [ShortDesc] [nvarchar](255) NULL,
                        [CurrentPeriod] [nvarchar](255) NULL,
                        [Yago] [bigint] NULL,
                        [Mago] [bigint] NULL,
                        [Wago] [tinyint] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Market]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Market](
                        [MktKey] [tinyint] NULL,
                        [MktDesc] [nvarchar](255) NULL,
                        [Seq] [tinyint] NULL,
                        [LevelX] [nvarchar](255) NULL,
                        [MkShortId] [nvarchar](255) NULL,
                        [District] [nvarchar](255) NULL,
                        [region] [nvarchar](255) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Forecast]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Forecast](
                        [MKTKEY] [tinyint] NULL,
                        [PERKEY] [bigint] NULL,
                        [UNITS] [decimal](29, 10) NULL,
                        [DOLLARS] [decimal](29, 10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Fact]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Fact](
                        [PERKEY] [bigint] NULL,
                        [PRODKEY] [int] NULL,
                        [MKTKEY] [tinyint] NULL,
                        [UNITS] [int] NULL,
                        [DOLLARS] [bigint] NULL,
                        [LOGON] [nvarchar](255) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QRTZ_JOB_DETAILS]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QRTZ_JOB_DETAILS](
                        [JOB_NAME] [varchar](80) NOT NULL,
                        [JOB_GROUP] [varchar](80) NOT NULL,
                        [DESCRIPTION] [varchar](120) NULL,
                        [JOB_CLASS_NAME] [varchar](128) NOT NULL,
                        [IS_DURABLE] [varchar](1) NOT NULL,
                        [IS_VOLATILE] [varchar](1) NOT NULL,
                        [IS_STATEFUL] [varchar](1) NOT NULL,
                        [REQUESTS_RECOVERY] [varchar](1) NOT NULL,
                        [JOB_DATA] [image] NULL,
 CONSTRAINT [PK_QRTZ_JOB_DETAILS] PRIMARY KEY CLUSTERED
(
                        [JOB_NAME] ASC,
                        [JOB_GROUP] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[QRTZ_FIRED_TRIGGERS]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QRTZ_FIRED_TRIGGERS](
                        [ENTRY_ID] [varchar](95) NOT NULL,
                        [TRIGGER_NAME] [varchar](80) NOT NULL,
                        [TRIGGER_GROUP] [varchar](80) NOT NULL,
                        [IS_VOLATILE] [varchar](1) NOT NULL,
                        [INSTANCE_NAME] [varchar](80) NOT NULL,
                        [FIRED_TIME] [bigint] NOT NULL,
                        [STATE] [varchar](16) NOT NULL,
                        [JOB_NAME] [varchar](80) NULL,
                        [JOB_GROUP] [varchar](80) NULL,
                        [IS_STATEFUL] [varchar](1) NULL,
                        [REQUESTS_RECOVERY] [varchar](1) NULL,
 CONSTRAINT [PK_QRTZ_FIRED_TRIGGERS] PRIMARY KEY CLUSTERED
(
                        [ENTRY_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[XMLP_SCHED_JOB]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[XMLP_SCHED_JOB](
                        [LAST_UPDATED] [datetime] NULL,
                        [CREATED] [datetime] NULL,
                        [BURSTING_PARAMETERS] [image] NULL,
                        [DELIVERY_PARAMETERS] [image] NULL,
                        [SCHEDULE_PARAMETERS] [image] NULL,
                        [REPORT_PARAMETERS] [image] NULL,
                        [LOCALE] [varchar](5) NULL,
                        [XSCHURL] [varchar](4000) NULL,
                        [DELIVERY_DESCRIPTION] [varchar](4000) NULL,
                        [SCHEDULE_DESCRIPTION] [varchar](100) NULL,
                        [END_DATE] [datetime] NULL,
                        [START_DATE] [datetime] NULL,
                        [BURSTING] [char](1) NULL,
                        [SHARED_OPTION] [char](1) NULL,
                        [RUN_TYPE] [char](1) NULL,
                        [USER_DESCRIPTION] [varchar](4000) NULL,
                        [USER_JOB_NAME] [varchar](1000) NULL,
                        [ISSUER] [varchar](100) NOT NULL,
                        [OWNER] [varchar](100) NOT NULL,
                        [REPORT_URL] [varchar](1000) NOT NULL,
                        [JOB_GROUP] [varchar](1000) NOT NULL,
                        [JOB_ID] [numeric](12, 0) NOT NULL,
PRIMARY KEY CLUSTERED
(
                        [JOB_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[SEQUENCE]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SEQUENCE](
                        [SEQ_NAME] [varchar](50) NOT NULL,
                        [SEQ_COUNT] [numeric](28, 0) NULL,
PRIMARY KEY CLUSTERED
(
                        [SEQ_NAME] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[QRTZ_SCHEDULER_STATE]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QRTZ_SCHEDULER_STATE](
                        [INSTANCE_NAME] [varchar](80) NOT NULL,
                        [LAST_CHECKIN_TIME] [bigint] NOT NULL,
                        [CHECKIN_INTERVAL] [bigint] NOT NULL,
                        [RECOVERER] [varchar](80) NULL,
 CONSTRAINT [PK_QRTZ_SCHEDULER_STATE] PRIMARY KEY CLUSTERED
(
                        [INSTANCE_NAME] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[QRTZ_PAUSED_TRIGGER_GRPS]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS](
                        [TRIGGER_GROUP] [varchar](80) NOT NULL,
 CONSTRAINT [PK_QRTZ_PAUSED_TRIGGER_GRPS] PRIMARY KEY CLUSTERED
(
                        [TRIGGER_GROUP] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[QRTZ_LOCKS]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QRTZ_LOCKS](
                        [LOCK_NAME] [varchar](40) NOT NULL,
 CONSTRAINT [PK_QRTZ_LOCKS] PRIMARY KEY CLUSTERED
(
                        [LOCK_NAME] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[XMLP_SCHED_SUBSCRIPTION]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[XMLP_SCHED_SUBSCRIPTION](
                        [LAST_UPDATED] [datetime] NULL,
                        [CREATED] [datetime] NULL,
                        [NOTIFICATION_DESTINATION] [varchar](200) NULL,
                        [NOTIFICATION_TYPE] [char](1) NULL,
                        [SUBSCRIBER] [varchar](100) NOT NULL,
                        [JOB_ID] [numeric](12, 0) NOT NULL,
                        [SUBSCRIPTION_ID] [numeric](12, 0) NOT NULL,
PRIMARY KEY CLUSTERED
(
                        [SUBSCRIPTION_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[XMLP_SCHED_OUTPUT]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[XMLP_SCHED_OUTPUT](
                        [DELETED] [char](1) NULL,
                        [LAST_UPDATED] [datetime] NULL,
                        [CREATED] [datetime] NULL,
                        [DOCUMENT_DATA_AVAILABLE] [char](1) NULL,
                        [DOCUMENT_DATA_COMPRESSED] [char](1) NULL,
                        [DOCUMENT_DATA_CONTENT_TYPE] [varchar](100) NULL,
                        [DOCUMENT_DATA] [image] NULL,
                        [XML_DATA_AVAILABLE] [char](1) NULL,
                        [XML_DATA_COMPRESSED] [char](1) NULL,
                        [XML_DATA_CONTENT_TYPE] [varchar](100) NULL,
                        [XML_DATA] [image] NULL,
                        [MESSAGE] [image] NULL,
                        [STATUS_DETAIL] [image] NULL,
                        [STATUS] [char](1) NULL,
                        [JOB_ID] [numeric](12, 0) NOT NULL,
                        [OUTPUT_ID] [numeric](12, 0) NOT NULL,
PRIMARY KEY CLUSTERED
(
                        [OUTPUT_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[QRTZ_JOB_LISTENERS]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QRTZ_JOB_LISTENERS](
                        [JOB_NAME] [varchar](80) NOT NULL,
                        [JOB_GROUP] [varchar](80) NOT NULL,
                        [JOB_LISTENER] [varchar](80) NOT NULL,
 CONSTRAINT [PK_QRTZ_JOB_LISTENERS] PRIMARY KEY CLUSTERED
(
                        [JOB_NAME] ASC,
                        [JOB_GROUP] ASC,
                        [JOB_LISTENER] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[QRTZ_TRIGGERS]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QRTZ_TRIGGERS](
                        [TRIGGER_NAME] [varchar](80) NOT NULL,
                        [TRIGGER_GROUP] [varchar](80) NOT NULL,
                        [JOB_NAME] [varchar](80) NOT NULL,
                        [JOB_GROUP] [varchar](80) NOT NULL,
                        [IS_VOLATILE] [varchar](1) NOT NULL,
                        [DESCRIPTION] [varchar](120) NULL,
                        [NEXT_FIRE_TIME] [bigint] NULL,
                        [PREV_FIRE_TIME] [bigint] NULL,
                        [TRIGGER_STATE] [varchar](16) NOT NULL,
                        [TRIGGER_TYPE] [varchar](8) NOT NULL,
                        [START_TIME] [bigint] NOT NULL,
                        [END_TIME] [bigint] NULL,
                        [CALENDAR_NAME] [varchar](80) NULL,
                        [MISFIRE_INSTR] [smallint] NULL,
                        [JOB_DATA] [image] NULL,
 CONSTRAINT [PK_QRTZ_TRIGGERS] PRIMARY KEY CLUSTERED
(
                        [TRIGGER_NAME] ASC,
                        [TRIGGER_GROUP] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[QRTZ_TRIGGER_LISTENERS]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QRTZ_TRIGGER_LISTENERS](
                        [TRIGGER_NAME] [varchar](80) NOT NULL,
                        [TRIGGER_GROUP] [varchar](80) NOT NULL,
                        [TRIGGER_LISTENER] [varchar](80) NOT NULL,
 CONSTRAINT [PK_QRTZ_TRIGGER_LISTENERS] PRIMARY KEY CLUSTERED
(
                        [TRIGGER_NAME] ASC,
                        [TRIGGER_GROUP] ASC,
                        [TRIGGER_LISTENER] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[QRTZ_SIMPLE_TRIGGERS]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS](
                        [TRIGGER_NAME] [varchar](80) NOT NULL,
                        [TRIGGER_GROUP] [varchar](80) NOT NULL,
                        [REPEAT_COUNT] [bigint] NOT NULL,
                        [REPEAT_INTERVAL] [bigint] NOT NULL,
                        [TIMES_TRIGGERED] [bigint] NOT NULL,
 CONSTRAINT [PK_QRTZ_SIMPLE_TRIGGERS] PRIMARY KEY CLUSTERED
(
                        [TRIGGER_NAME] ASC,
                        [TRIGGER_GROUP] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[QRTZ_CRON_TRIGGERS]    Script Date: 02/08/2012 11:56:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QRTZ_CRON_TRIGGERS](
                        [TRIGGER_NAME] [varchar](80) NOT NULL,
                        [TRIGGER_GROUP] [varchar](80) NOT NULL,
                        [CRON_EXPRESSION] [varchar](80) NOT NULL,
                        [TIME_ZONE_ID] [varchar](80) NULL,
 CONSTRAINT [PK_QRTZ_CRON_TRIGGERS] PRIMARY KEY CLUSTERED
(
                        [TRIGGER_NAME] ASC,
                        [TRIGGER_GROUP] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  ForeignKey [FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS]    Script Date: 02/08/2012 11:56:09 ******/
ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS]  WITH CHECK ADD  CONSTRAINT [FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY([TRIGGER_NAME], [TRIGGER_GROUP])
REFERENCES [dbo].[QRTZ_TRIGGERS] ([TRIGGER_NAME], [TRIGGER_GROUP])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] CHECK CONSTRAINT [FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS]
GO
/****** Object:  ForeignKey [FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS]    Script Date: 02/08/2012 11:56:09 ******/
ALTER TABLE [dbo].[QRTZ_JOB_LISTENERS]  WITH CHECK ADD  CONSTRAINT [FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS] FOREIGN KEY([JOB_NAME], [JOB_GROUP])
REFERENCES [dbo].[QRTZ_JOB_DETAILS] ([JOB_NAME], [JOB_GROUP])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[QRTZ_JOB_LISTENERS] CHECK CONSTRAINT [FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS]
GO
/****** Object:  ForeignKey [FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS]    Script Date: 02/08/2012 11:56:09 ******/
ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS]  WITH CHECK ADD  CONSTRAINT [FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY([TRIGGER_NAME], [TRIGGER_GROUP])
REFERENCES [dbo].[QRTZ_TRIGGERS] ([TRIGGER_NAME], [TRIGGER_GROUP])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] CHECK CONSTRAINT [FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS]
GO
/****** Object:  ForeignKey [FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS]    Script Date: 02/08/2012 11:56:09 ******/
ALTER TABLE [dbo].[QRTZ_TRIGGER_LISTENERS]  WITH CHECK ADD  CONSTRAINT [FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS] FOREIGN KEY([TRIGGER_NAME], [TRIGGER_GROUP])
REFERENCES [dbo].[QRTZ_TRIGGERS] ([TRIGGER_NAME], [TRIGGER_GROUP])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[QRTZ_TRIGGER_LISTENERS] CHECK CONSTRAINT [FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS]
GO
/****** Object:  ForeignKey [FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS]    Script Date: 02/08/2012 11:56:09 ******/
ALTER TABLE [dbo].[QRTZ_TRIGGERS]  WITH CHECK ADD  CONSTRAINT [FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS] FOREIGN KEY([JOB_NAME], [JOB_GROUP])
REFERENCES [dbo].[QRTZ_JOB_DETAILS] ([JOB_NAME], [JOB_GROUP])
GO
ALTER TABLE [dbo].[QRTZ_TRIGGERS] CHECK CONSTRAINT [FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS]
GO
/****** Object:  ForeignKey [FK_JOB_ID_OUTPUT]    Script Date: 02/08/2012 11:56:09 ******/
ALTER TABLE [dbo].[XMLP_SCHED_OUTPUT]  WITH CHECK ADD  CONSTRAINT [FK_JOB_ID_OUTPUT] FOREIGN KEY([JOB_ID])
REFERENCES [dbo].[XMLP_SCHED_JOB] ([JOB_ID])
GO
ALTER TABLE [dbo].[XMLP_SCHED_OUTPUT] CHECK CONSTRAINT [FK_JOB_ID_OUTPUT]
GO
/****** Object:  ForeignKey [FK_JOB_ID_SBSC]    Script Date: 02/08/2012 11:56:09 ******/
ALTER TABLE [dbo].[XMLP_SCHED_SUBSCRIPTION]  WITH CHECK ADD  CONSTRAINT [FK_JOB_ID_SBSC] FOREIGN KEY([JOB_ID])
REFERENCES [dbo].[XMLP_SCHED_JOB] ([JOB_ID])
GO
ALTER TABLE [dbo].[XMLP_SCHED_SUBSCRIPTION] CHECK CONSTRAINT [FK_JOB_ID_SBSC]
GO

  43)
 
  44) Click on delivery configuration
  
   45) Specify  email address from where it has deliver in Email from address ,In delivery notification email from address i.e for which adress the notification has to go then  click apply.


      
2  46) Now select Email tab and select add server.
    47) Server name SMTP, Host name  and port number of your respected mail id. In username specify mail id username and password finally apply.
     48)  Select Schedule for which report u want to schedule.
      49)  Now select Schedule a new job.
     50)


      Here u select the check box of ‘Public’ in JOB PROPERTIES, In notification select EMAIL, Then schedule the report in TIME, Specify the To email address cc address ,Subject finally submit. If it succeeds u will get the schedule report to specified mail id.

     

Posted by at 2 comments:
Labels: , ,
Subscribe to: Posts (Atom)