packaging scheduled jobs

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

packaging scheduled jobs

Postby jbrown » Sat Sep 13, 2008 2:07 am

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?
jbrown
 
Posts: 12
Joined: Sat Sep 13, 2008 2:05 am

Postby chris.buckingham » Mon Sep 15, 2008 10:52 am

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
chris.buckingham
 
Posts: 56
Joined: Mon Jul 30, 2007 1:39 pm

packaging data in msdb

Postby jbrown » Mon Sep 15, 2008 5:27 pm

Thank you for the reply.

I've noticed in a thread from May '08 the following


Also i would like to append scripted scheduled jobs that are written to the msdb database. Can I achieve this by simply editing the package1.resx file...?
http://www.red-gate.com/MessageBoard/vi ... light=msdb


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 ...?
jbrown
 
Posts: 12
Joined: Sat Sep 13, 2008 2:05 am

Postby David Atkinson » Mon Sep 15, 2008 5:36 pm

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

msdb

Postby jbrown » Mon Sep 15, 2008 10:22 pm

Yes, I believe that would be very helpful. Thanks very much.
jbrown
 
Posts: 12
Joined: Sat Sep 13, 2008 2:05 am

Postby David Atkinson » Mon Sep 15, 2008 10:40 pm

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby Chris Auckland » Wed Sep 24, 2008 1:51 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest