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

  1. Write a SELECT statement to access the Employee, Job Title, Vacation Hours, and Sick Hours information.
  2. Schedule a job to run on the first day of each month and title it "PTO/SICK Report."
  3. 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.
  4. Create a SQL transaction that manages the scheduling of PTO/SICK Report as well as a periodic database backup.
  5. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

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

Q:

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

Q:

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

Q:

Really having a hard time on this assignment. Details: This assignment serves to benchmark competencies 1.5: Apply knowledge of database architecture and design to meet organizational needs and In...

Q:

From the AdventureWorks SQL Server test relational database: The sales manager frequently receives customer feedback in the form of sales representative compliments from customers. However, customers...

Q:

hope this is the structure your looking for. I just need the code to use in order to solve these query searches. how to find the questions all the information should be there In this assignment,...

Q:

The purpose of this assignment is to explore multidimensional querying in a data warehouse. Use the data warehouse that is part of the "AdventureWorks 2016 and Scripts for SQL Server 2016 CTP3" you...

Q:

Its using the database Adventureworks CTP3 if you can be as detailed as you can with what database I can provide to make this easier. In this assignment, students will use the AdventureWorks CTP3...

Q:

what is the database design where do I find that? In this assignment, students will use the AdventureWorks CTP3 database and practice writing CASE, SET, and DECLARE statements to build a stored...

Q:

Hello everyone Im having some difficulty with this question and have very little of the code written before I ran into some problems , using adventureworks 2014 database with SQL Create a Word...

Q:

For this project, you will build a portfolio of 8 assets plus the S&P 500 from the following options (9 assets in all): Asset Group Bulldog: (select 2 stocks from this group. You can't pick three in...

Q:

When attempting to identify project risks there are various tools that a project manager can use. Apply the Fishbone analysis to a project that you are familiar with in order to identify the project...

Q:

where do you find financial foot note on a 1 0 k ?

Q:

Which of the following statements is true? None of the statements in this question are true. The daily settlement of futures contracts reduces exchange rate risk relative to forward contracts. If a...

Q:

1. How have the origins of the study of intercultural communication in the United States affected its present focus?

Q:

5. Identify three characteristics of the dialectical approach.

Q:

7. Identify six intercultural communication dialectics.