ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Job Proxy management in running SSIS package job

Job Proxy management in running SSIS package job

原创 Linux操作系统 作者:italucia 时间:2009-06-18 17:47:08 0 删除 编辑
In my project, I ceate an SSAS project and i need to find a way to periodically process the cubes automatically. 
The idea is that at first creating an SSIS package aiming at processing the cubes. 
Then creat a SQL Server agent job to run the SSIS package, further more, tto schedule the  job and run the SSIS package periodically. 
Since it needs to bypass the security layer in SQL SERVER, the job agent account is needed. 
Therefore, three important thing:
  •  Create one new ‘credential’ 
  •   Create one new proxy agent account
  • .  Add job based on the new created  proxy agent account
It works fine. 
However, since the proxy agent account is created on 'domain\windowsAccount', in the case of the change of the password for the 'domain\WindowsAccount', it doesn't work any more. 
The solution is modifying the proxy agent account with the new passowrd and bind the job with the proxy agent. 
It works again :) 
The code are as following :

Use master

CREATE CREDENTIAL [JobProcessCredential] WITH IDENTITY = 'domain\windowsAccount', secret = '**********'

 

USE msdb ;

GO

EXEC dbo.sp_add_proxy

@proxy_name = 'JobProcessProxy',

    @enabled = 1,

    @credential_name = 'JobProcessCredential' ;

GO

EXEC dbo.sp_grant_proxy_to_subsystem

    @proxy_name = N'JobProcessProxy',

    @subsystem_name = N'ssis' ;

GO


1.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12374161/viewspace-606720/,如需转载,请注明出处,否则将追究法律责任。

下一篇: Roles in the Cube
请登录后发表评论 登录
全部评论

注册时间:2009-05-08

  • 博文量
    28
  • 访问量
    27752