scheduled jobbs

The purpose of this assignment is to practice automating queries through scheduling a job on the system.

Each month the workforce management team calculates PTO/SICK time remaining for the rest of the year in order to plan vacations. The team has requested a report that lists the Employee, Job Title, Vacation Hours, and Sick Hours. The team would like the report to generate on the first day of each month.

For this assignment, you will need to complete the following steps to enable the SQL Server Agent:

1. Go to “RUN:” in Windows Explorer and type “services.msc.”
2. Double click on “SQL Server Agent (MSSQLSERVER)” and change it to “automatic.”
3. Close and launch “SQL Server Configuration Manager.”
4. Left click on “services.”
5. Start SQL Server Agent.

Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to a Microsoft Excel file for a visual check of accuracy.

Create a Microsoft Word document that includes the SQL query code used to execute the steps below in the “AdventureWorksDW2017” 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.

1. Create a SQL transaction that manages the scheduling of PTO/SICK Report as well as a periodic database backup.
2. Copy and paste the SELECT query, screenshot of the scheduler configuration, and the SQL transaction into a Word document.

Compile the Excel data file and the Word document into a .zip file and submit to your instructor.

APA style is not required, but solid academic writing is expected.