Database II Undram Sambuu HomeBrewR Overview Steps to create - PowerPoint PPT Presentation

Database II Undram Sambuu HomeBrewR

Overview • Steps to create SSIS Package • STORED PROCEDURES • Steps to create JOB

S S IS • SQL Server Integration Services ( SSIS ) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migrationtasks.

S TORED PROCEDURES • Stored Procedures are a batch of SQL statements that can be executed as a job. • Benefits: centralize data access logic, security • Syntax: • CREATE PROCEDURE (NAME OF THE PROCEDURE) SP_SU_HOMEBREWR AS SELECT *, CAST( GETDATE()AS DATE) DATESTAMP FROM ABDDWSAND.dbo.SU_HOMEBREWR

JOB • A job is a specified series of actions that SQL Server Agent performs. Use jobs to define an administrative task that can be run one or more times and monitored for success or failure. • Benefits: can be scheduled, sends notification