Azure sql managed instance SQL agent job output step results to file

sakuraime 2,326

There are ability that SQL agent job can output step results to file.
however in Azure sql managed instance SQL agent job, the option is greyed out.

how to do that ?

1 answer

Ronen Ariely 15,191 Reputation points

2020-10-11T10:30:15.38+00:00

Hi,

step 1:

Try to use Log to table + Include step output in history

This will log all the full message to the job table

Step 2:

If you need to out to file you can do it using Azure Logic Apps and pull the information from the table to a file in the blob for example: https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-sqlazure

note: I did not try this option for jobs yet, but in first glance it seems like an option.

Note! If you will open a suggestion to support this feature in managed instance using blob for example to store the file, then I will vote it: https://feedback.azure.com/forums/908035-sql-server
Please sign in to rate this answer.
sakuraime 2,326 Reputation points

2020-10-11T12:29:24.223+00:00

thanks. any other work around ?
what about data factory store procedure activity ?

Ronen Ariely 15,191 Reputation points

2020-10-11T12:57:04.827+00:00

Well... once you did step 1 then the information is already stored.

The question is what exactly you want next.

Yes, you are right. You can use Azure Data Factory for the second step, but who will trigger the execution?

There are multiple ways to export the data to a file.

Logic apps allows you to manually or automatically executed when the data is changed. ADF usually used to manually execute the procedure or schedule it.

If you choose to use ADF then check this link for more information on trigger an event, It might be part of your solution: https://learn.microsoft.com/en-us/azure/data-factory/how-to-create-event-trigger

Choose what best fit your needs :-)

sakuraime 2,326 Reputation points

2020-10-13T03:25:51.473+00:00

any real example ?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure sql managed instance SQL agent job output step results to file

1 answer

Your answer