This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Run SQL Job from MsAccess to refresh Cube

Question
0

Sign in to vote
I have created a front end, in MsAccess, to make changes to budget numbers used in a Budget Cube.
I also have a Job in sql 2007 that executes the SP to reload the cube tables and process the cube.
Is there any way, From MsAccess, to Launch the Job, Or to execute the SQL (I know how to do this), and then process the cube (The part I am missing.)

Jim Hoffman
- Moved by Bruno Yu Tuesday, June 10, 2008 8:14 AM Off-Topic in VB.NET forum, you can post in VBA or VSTO forum for the expert support.
Tuesday, June 3, 2008 3:58 PM

Answers

0

Sign in to vote
You can create a macro in Access that calls sp_start_job and start up your job. You have to have fairly high permissions to do this, so that might not be an option.
- Marked as answer by Ed Price - MSFTMicrosoft employee Friday, May 11, 2012 2:28 AM
Thursday, June 19, 2008 2:49 PM
0

Sign in to vote
This thread was moved into the Off Topic forum. I can move it into a specific forum for you if you want.

Thanks!
Ed Price (a.k.a User Ed), SQL Server Experience Program Manager (Blog, Twitter, Wiki)
- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, May 11, 2012 2:45 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Friday, May 11, 2012 2:45 AM
Friday, May 11, 2012 2:28 AM

All replies

0

Sign in to vote
You can create a macro in Access that calls sp_start_job and start up your job. You have to have fairly high permissions to do this, so that might not be an option.
- Marked as answer by Ed Price - MSFTMicrosoft employee Friday, May 11, 2012 2:28 AM
Thursday, June 19, 2008 2:49 PM
0

Sign in to vote
This thread was moved into the Off Topic forum. I can move it into a specific forum for you if you want.

Thanks!
Ed Price (a.k.a User Ed), SQL Server Experience Program Manager (Blog, Twitter, Wiki)
- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, May 11, 2012 2:45 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Friday, May 11, 2012 2:45 AM
Friday, May 11, 2012 2:28 AM