The sql-server-agent tag has no wiki summary.
3
votes
1answer
571 views
How to succesfully run a batch file in an SQL Agent job?
I have a SQL Agent Job which generates a specific report in PDF-file and then copies the PDF to a network directory and then deletes the PDF file in the source directory.
The SQL Jobs consists of 2 ...
0
votes
1answer
70 views
SQL Agent embedded PowerShell script in CmdExec step fails with import-module sqlps
SQL Server 2008R2
PowerShell 2.1
I am trying to create a SQL Agent job that dynamically backs up all non-corrupted SSAS databases on an instance without the use of SSIS. In my SQL Agent job, when I ...
2
votes
0answers
113 views
SQL Server Event Alerts Lack Enough Details
I setup SQL Server Alerts to send me emails whenever certain events (by severity) occur. Below is an example of en email I received for a "014 - Insufficient Permission" severity event of Type "SQL ...
1
vote
0answers
82 views
Requesting advice on creating a table controlled SQL job scheduler
I have been tasked with cleaning up a series of SQL jobs that send email updates about various data and system conditions in my company. Currently, there are a ton of jobs, each with its own SQL code ...
1
vote
0answers
451 views
Why is the next scheduled run date for my SQL Server job NULL?
I've been dealing with the Microsoft SQL Server Agent with regards to scheduling jobs.
I'm trying to find out what the next scheduled run date for a bunch of jobs that were created where the job ids ...
