| Author |
Message |
jbrown
Joined: 13 Sep 2008
Posts: 12
|
 Posted: Sat Sep 13, 2008 2:07 am Post subject: packaging scheduled jobs |
 |
|
| I'm sorry if this has been asked before: is it possible to include in a package several schedule jobs that need to be included with the database? |
|
| Back to top |
|
 |
chris.buckingham
Joined: 30 Jul 2007
Posts: 56
|
| Posted: Mon Sep 15, 2008 10:52 am Post subject: |
|
|
Unfortunately it isn't possible to package scheduled jobs (I assume you mean through SQL Server Agent) - SQL Packager will only package databases in the instance.
_________________
Chris Buckingham
Red-Gate support |
|
| Back to top |
|
|
jbrown
Joined: 13 Sep 2008
Posts: 12
|
| Posted: Mon Sep 15, 2008 5:27 pm Post subject: packaging data in msdb |
|
|
Thank you for the reply.
I've noticed in a thread from May '08 the following
Our situation is similar: we must package and deploy user databases along with supporting scheduled jobs to client sites that are locked down and firewalled. So, we are looking for a solution that can enable a client to use a simple executable by which they can create a user database schema, a few lookup tables, database logins, and a small number of enabled scheduled jobs.
It sounds like from the post I've quoted above that this might be possible in SQL Packager, if it's approached cleverly through the API ...? |
|
| Back to top |
|
|
David Atkinson
Joined: 05 Dec 2005
Posts: 1079
|
| Posted: Mon Sep 15, 2008 5:36 pm Post subject: |
|
|
We're very close to releasing a new version of SQL Packager which will allow any script to be loaded to the tool and packaged. This means that you will be able to generate an upgrade script using SQL Packager, save it as a .sql script, edit it as you desire, and package this up as an exe.
Would this satisfy your requirements?
Kind regards,
David Atkinson
Product Manager
Red Gate Software |
|
| Back to top |
|
|
jbrown
Joined: 13 Sep 2008
Posts: 12
|
| Posted: Mon Sep 15, 2008 10:22 pm Post subject: msdb |
|
|
| Yes, I believe that would be very helpful. Thanks very much. |
|
| Back to top |
|
|
David Atkinson
Joined: 05 Dec 2005
Posts: 1079
|
| Posted: Mon Sep 15, 2008 10:40 pm Post subject: |
|
|
I've asked our support department to raise a ticket so you'll be notified when v6.0 has been released. It should be a matter of a few weeks now.
Kind regards,
David Atkinson
Red Gate Software |
|
| Back to top |
|
|
Chris Auckland
Joined: 24 Oct 2006
Posts: 710
Location: Red Gate Software Ltd.
|
| Posted: Wed Sep 24, 2008 1:51 pm Post subject: |
|
|
I just wanted to let you know that the new version of packager is available from our website.
You can download the update by using the 'check for updates' function within the tool.
_________________
Chris |
|
| Back to top |
|
|
|
