New answers tagged

-2

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] ,[Occurs] = CASE [schedule].[freq_type] WHEN 1 THEN 'Once' ...


1

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, ...


2

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 ...


1

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 ...


1

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 ...


Top 50 recent answers are included