SELECT [JobName] = [jobs].[name]
,[Category] = [categories].[name]
,[Owner] = SUSER_SNAME([jobs].[owner_sid])
,[Enabled] = CASE [jobs].[enabled] WHEN 1 THEN 'Yes' ELSE 'No' END
,[Scheduled] = CASE [schedule].[enabled] WHEN 1 THEN 'Yes' ELSE 'No' END
,[Description] = [jobs].[description]
WHEN 1 THEN 'Once'
You might want to consider a SSIS package to incorporate your conditional execution logic.
Assuming you have a two-step SSA job, both executing T-SQL statements, you could create a SSIS package with three Execute SQL tasks.
Task 1 would execute the SQL for your first business process.
Task 2 would execute a check, like for the result of a control table, ...
One solution is to use multiple job steps and branch depending on the success/failure condition of the business condition - but that means the job will produce that "dreaded" yellow triangle and red circle for the step.
A second solution is to use 3 jobs and call one of two jobs based on the result of the business condition.
STEP 1 : Do something
With global Temp Tables, when the session that created it no longer exists and no other T-SQL statements are actively referencing the table, it gets dropped automatically.
Per Microsoft's Create Table docs:
Global temporary tables are automatically dropped when the session
that created the table ends and all other tasks have stopped
referencing them. The ...
As far as I understand, your task is not so much to make a backup - how to automatically restore it to another RDS SQL Server in the development environment.
In general, there are two ways on how to achieve it:
Create a native backup and restore it to dev
Export \ Import Data tier application
Amazon RDS SQL Server does not support the BACKUP DATABASE ...