I need to run a query against a SQL DB in Excel so I can use Task Scheduler
and run the Excel File every 6 hours. I created the update query in Access.
SQL Server Name: SQL
Database: Production
Table: Job

Heres the SQL query from Access:
UPDATE Job SET Job.Priority = 0
WHERE (((Job.Job) Like "F*") AND ((Job.Status)="Active") AND
((Job.Priority)0) AND ((Job.Sched_Start) Is Not Null));