visual-studio-2012sql-server-2012-datatoolssql-data-tools

Creating SQL Agent JOBs in SQL Server 2012 Database Projects from VS 2012

I am working on Visual Studio 2012 with Update 2 + SQL Server Data Tools and I am able work on the SQL Server Database Projects.

How do I create/add new SQL Agent JOB into this database project? Because if I click Add - New Item... I don't see anything for Job.

I know Jobs are related to SQL Server and the Database Project is related to a SQL Database. But I was wondering how do manage the SQL Jobs?

Thanks,
Prabhat

Solution

  • Jobs aren't supported natively. It might be possible to add these from the post-deployment script, although it's not something I've tried.