Red Gate forums :: View topic - packaging scheduled jobs
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager Previous Versions
SQL Packager Previous Versions forum

packaging scheduled jobs

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
jbrown



Joined: 13 Sep 2008
Posts: 12

PostPosted: Sat Sep 13, 2008 2:07 am    Post subject: packaging scheduled jobs Reply with quote

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
View user's profile Send private message
chris.buckingham



Joined: 30 Jul 2007
Posts: 56

PostPosted: Mon Sep 15, 2008 10:52 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
jbrown



Joined: 13 Sep 2008
Posts: 12

PostPosted: Mon Sep 15, 2008 5:27 pm    Post subject: packaging data in msdb Reply with quote

Thank you for the reply.

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


Quote:
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/viewtopic.php?t=6981&highlight=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 ...?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1121
Location: Twitter: @dtabase

PostPosted: Mon Sep 15, 2008 5:36 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
jbrown



Joined: 13 Sep 2008
Posts: 12

PostPosted: Mon Sep 15, 2008 10:22 pm    Post subject: msdb Reply with quote

Yes, I believe that would be very helpful. Thanks very much.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1121
Location: Twitter: @dtabase

PostPosted: Mon Sep 15, 2008 10:40 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Wed Sep 24, 2008 1:51 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group