Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a Word document that includes the SQL query code used to execute the steps below in the AdventureWorksDW2016CTP3 database. Write a SELECT statement to
Create a Word document that includes the SQL query code used to execute the steps below in the "AdventureWorksDW2016CTP3" database.
- Write a SELECT statement to access the Employee, Job Title, Vacation Hours, and Sick Hours information.
- Schedule a job to run on the first day of each month and title it "PTO/SICK Report."
- Take a screenshot of the report setup screen to illustrate how you designed the report. Paste the screenshot into a Word document as record of the report.
- Create a SQL transaction that manages the scheduling of PTO/SICK Report as well as a periodic database backup.
- Copy and paste the SELECT query, screenshot of the scheduler configuration, and the SQL transaction into a Word docum
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started