0

In our SQL Server 2008 Agent properties dialog box we have set an Alert System settings as shown below. But when we try to generate a script for that we get the following message - hence unable to generate a T-SQL script. Is there a T-SQL script or stored procedure to create such setting:

enter image description here

UPDATE Please note that this is not to create an alert. Instead, it's an step shown here to set the System Alert property of the SQL Server Agent when configuring a Database Mail (also shown in the above link)

nam
  • 21,967
  • 37
  • 158
  • 332
  • 2
    I think you made the changes earlier and now you are trying to script them out, You will need to revert the changes and save it and come out of it, open the properties section again make the changes and before you save them then click on `Script` and it will generate the script for you. – M.Ali Sep 28 '15 at 21:55
  • @M.Ali Please see my comments below. – nam Sep 29 '15 at 03:00
  • I misunderstood your question. Given your update, I agree with @M.Ali. Either undo your change and re-do it but hit the Script button before you hit "OK" in the dialog or implement the change on a system where it hasn't been implemented yet and do the same (i.e. hit Script before OK). – Ben Thul Sep 29 '15 at 03:25

0 Answers0