I am working on migrating our application on windows Azure, I have migrated our database on sql azure. but for one functionality I am facing issues with. in our application we create a sql jobs through the stored procedure by running the code like
EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=@Name,
@notify_level_eventlog=2, -- This will delete the Job on Success. 0 null, 1 success, 2 fail, 3 always
@delete_level=1, -- This will delete the Job on Success. 0 null, 1 success, 2 fail, 3 always
@description=N'Bulk Update price for the User',
@owner_login_name=N'SA', @job_id = @jobId OUTPUT
Can you please help me to work with SQL Azure. Basically we are looking for solution where we can create the sql jobs through the sql script only like stored procedures.
Thank you for your help