Connect to SQL Azure from the On-Premises SQL Server Agent



    The General Guidelines and Limitations (SQL Azure Database) states that,

    SQL Azure Database does not support SQL Server Agent or jobs. You can, however, run SQL Server Agent on your on-premise SQL Server and connect to SQL Azure Database.

    I need to execute a stored procedure on a SQL Azure DB as part of the on-premises SQL job. Checked the SQL step creation process within the job, but couldn't figure how to connect to SQL Azure DB from the job. Could anyone point me in the right direction?







    Tuesday, February 01, 2011 6:53 PM


All replies