schedule and run jobs to refresh data for QlikView... - Qlik Community

Report Inappropriate Content · ‎2012-01-27

Hi Team,

Need an informantion on scheduling / running jobs to refresh data for Qlikview reports for below scenario's -

Small Business Server Edition

Enterprise Server Edition

Enterprise with Publisher

Thanks in advance,

Joyking

vikasmahajan · ‎2012-01-27

Steps for scheduling and jobs in Sql Sever for Qlikview

Go to server of Qlikview

EXEC sp_addlinkedserver @server='Server Name'

Create database in local sql server for storing data for qlikview

Edit script which will be fateching data in views or temporary tables from source to local db

Give use Qlikview_module name in case of payroll software and change all scripts with \from server

name.db name.dbo.table name.

Go to sql server agent

Select Job

Right Click to Job -> New

Create new job

Give Job Name

Steps-> New -> Give Step name as "STEP1"

Select Database -> Qlikview_module namel in case of any software.

Click on open button -> Select Script <For Masters as well as Transactions>.

Select <Advanced> and On sucessful action-> Quit report.

Select Retry option with for e.g. <5> nos.

Select Interval for e.g. <1> minutes.

Output File -> Give output file name i.e. <Log Filename>

Select Append option

Select Schedule < For Scheduling job>
Give name to schedule

Select Recurring option and tick on Enabled <Tick>

Occur's -> Daily option

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2012-02-01

Thanks for your reply, but I want to know the steps involved in the scheduling QVW file which creates the QVD which goes as a data source for my presentation layer QVW file.

Regards,

Keerthy

schedule and run jobs to refresh data for QlikView reports