Skip to content Skip to sidebar Skip to footer
Showing posts with the label Jobs
How Do I Grant Access To Sql Server Agent To Be Able To Write/modify System Files?

How Do I Grant Access To Sql Server Agent To Be Able To Write/modify System Files?

Post a Comment
I have a job that has a stored procedure that runs BCP to QUERYOUT some data. If I run the QUERYOUT… Read more How Do I Grant Access To Sql Server Agent To Be Able To Write/modify System Files?
Running Powershell Scripts Through Sql

Running Powershell Scripts Through Sql

Post a Comment
I have a script that runs Invoke-SQLCmd against a SQLServer called Server1. Data that is collected … Read more Running Powershell Scripts Through Sql
How To Automatically Stop Sql Server Agent When No Jobs Are Running?

How To Automatically Stop Sql Server Agent When No Jobs Are Running?

Post a Comment
I have around 40 different sql server jobs in one instance. They all have different schedules. Some… Read more How To Automatically Stop Sql Server Agent When No Jobs Are Running?