• If your app has access to delete data on your server, does it also ave access to run a job? If the app kicks off the job only after its done its processing then you won't have any downtime between the two steps. It could use something like:

    EXEC msdb..sp_start_job @job_name= 'jobname here'



    SQL Tips and Scripts
    SQLWorks Blog