0

If i am not wrong Azure Portal Database not have The SQL Agent.My azure database Integration Service Catalogs is bellow. What is the recommended way to schedule SSIS routine jobs. enter image description here

What is the recommended way to schedule routine jobs? Is it possible in Azure ?

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30
shamim
  • 6,640
  • 20
  • 85
  • 151
  • is this a VM or SQL Azure? is it possible for you to schedule a job as it is done in on-prem MSSQL? – Isham Mohamed Oct 20 '17 at 12:20
  • @ Isham Mohamed I have portal.azure not any VM. – shamim Oct 20 '17 at 12:58
  • How do you even get a SSIS catalog in SQL Azure DB? As far as I know this is not supported. Are you 100% certain this is not a VM? – Nick.Mc Oct 20 '17 at 13:22
  • Interesting... so this is now supported. Following @Alberto link yields this: https://learn.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-schedule-packages – Nick.Mc Oct 20 '17 at 13:27
  • @Nick.McDermaid you can also follow Sreedhar-Pelluru link https://learn.microsoft.com/en-us/azure/data-factory/tutorial-deploy-ssis-packages-azure – shamim Oct 20 '17 at 13:45

1 Answers1

2

You need to use Azure Data Factory as stated on this official documentation.some more info

Azure Data Factory hosts the runtime engine for SSIS packages on Azure. The runtime engine is called the Azure SSIS Integration Runtime (SSIS IR).

When you provision the SSIS IR, you can scale up and scale out by specifying values for the following options:

  • The node size (including the number of cores) and the number of nodes in the cluster.
  • The existing instance of Azure SQL Database to host the SSIS Catalog Database (SSISDB), and the service tier for the database. The maximum parallel executions per node.
TheGameiswar
  • 27,855
  • 8
  • 56
  • 94
Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30