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)