2 Replies Latest reply: Mar 5, 2012 9:13 AM by Joris Oster RSS

    creating a control qvw file for power users.

      Hi,

       

      I would like to create a "control" qvw file published on accesspoint and having 3 butons to execute the following tasks:

      -Open an external web form (this aspx web form will modify some data in my SQL server database)

      -Execute a stored procedure to rebuild the source tables that will loaded in qvw files

      -Reload the qvw files concerned by these tables

       

      At the moment, we are using QVS10 without publisher. This "control" file is accessible by the power users identified as such by the DMS authorisation

      Do you see any limitation or obstacle to do it?

       

      Thanks for your answer.

       

      Joris

        • Re: creating a control qvw file for power users.
          Tanel Rüütli

          I assume it is MS sql server 2008/2005.

          It is possible to execute sql server job externally.

          The job would execute the stored procedures and finally reload qvw-s (via batch command).

           

          Limitations:

          To start a job at a remote SQL server, the user's machine need to have SQLCMD installed.

          SQLCMD is already installed if there is SQL server (2008/2005).

          If SQL server is not installed, you need following components

          - Microsoft® SQL Server® 2008 R2 Native Client

          - Microsoft® SQL Server® 2008 R2 Command Line Utilities

          Download (for win server 2008):  http://www.microsoft.com/download/en/details.aspx?id=16978

           

          example command of starting a job "QVTables" on server "sqlsrv1":

          "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE" -S "sqlsrv1" -Q "execute msdb.dbo.sp_start_job @job_name = 'QVTables' "

           

          I guess you could simply assign that command to QV button with "launch" action.

          The drawback is that there is no feedback about the progress, success or failure of the job.