2 Replies Latest reply: Feb 1, 2012 3:58 AM by KEERTHY VISHWESHWARACHAR RSS

    schedule and run jobs to refresh data for QlikView reports

    KEERTHY VISHWESHWARACHAR

      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

        • Re: schedule and run jobs to refresh data for QlikView reports
          vikas mahajan

                           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