execute a stored job through MS ACCESS 2000
From: Oskar (o_vaia@hotmail.com)
Date: 08/31/02
- Next message: John Bell: "Re: logged in user can't see tables"
- Previous message: pablo: "logged in user can't see tables"
- Next in thread: Sue Hoegemeier: "Re: execute a stored job through MS ACCESS 2000"
- Reply: Sue Hoegemeier: "Re: execute a stored job through MS ACCESS 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Oskar" <o_vaia@hotmail.com> Date: Sat, 31 Aug 2002 10:00:37 +0200
hi,
i would like to execute a stored job through MS ACCESS 2000 from a
client-pc, who is not member of the sysadmin-roule.
the job execute a DTS package.
here my code in VBA:
---- ---- dim conn as ADODB.connection set conn = new ADODB.connection conn.open "Provider=SQLOLEDB;Data Source=SQLSERVER;Initial Catalog=salesDB;Integrated Security=SSPI;" conn.execute "EXEC msdb.dbo.sp_start_job @job_name = 'salesstat'" conn.close set conn = nothing ---- when i try to run the makro then it'll not function. on the server is running SQL Server 2000 with SP2. the server use windows authentication. what must i do to run the job with a non sysadmin-member-account? what is the PROXY ACCOUNT and how is it to use? thx and bye Oskar (sorry, for my english!)
- Next message: John Bell: "Re: logged in user can't see tables"
- Previous message: pablo: "logged in user can't see tables"
- Next in thread: Sue Hoegemeier: "Re: execute a stored job through MS ACCESS 2000"
- Reply: Sue Hoegemeier: "Re: execute a stored job through MS ACCESS 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]