BI PUBLISHER
1) To configure for BI publisher follow the configuration method.
3) Login to obi presentation.
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)
25) We can create new layouts for the reports instead of existing one….select new
41) Final view when we add to dashboard.
48) Select
Schedule for which report u want to schedule.
49) Now
select Schedule a new job.
50)
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.
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
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.
35) After
adding fields u can preview the results.
37) After saving the report u should upload template to the existing report .
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.
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.
No comments:
Post a Comment