SQL Server Management Studio (SSMS) Cannot Script SQL Agent Jobs

I have been testing SSMS 2016 and I wanted to script out some SQL Agent jobs.  When attempting to do so, I ran across an error.

Discover dependencies failed.  Job is not supported in dependency discovery.

image

The description under additional information isn’t very helpful.  If it was labeled SQL Agent jobs do not support dependency discovery it would be better.  This error occurs when the Generate Scripts for dependent objects option is enabled under scripting. 

To disable it, do the following:

1. Select Tools, then Options…

image

2. Select SQL Server Object Explorer, then Scripting

3. Under Object scripting options, change Generate scripts for dependent objects to False

image

Advertisements
This entry was posted in Database Administration, SQL Server Management Studio and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s