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.
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 ...?
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.
Comments
Red-Gate support
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 ...?
Would this satisfy your requirements?
Kind regards,
David Atkinson
Product Manager
Red Gate Software
Product Manager
Redgate Software
Kind regards,
David Atkinson
Red Gate Software
Product Manager
Redgate Software
You can download the update by using the 'check for updates' function within the tool.