I have followed many articles to create an SSIS pipeline package, deploy it and schedule it.
I’m trying to transfer data from two remote servers, an OLEDB driver that connects to a SQL Server Database as a Source and an OLEDB provider for ODBC drivers that connects to a MySQL Database as a Destination…
I know how to solve the issue, but I don’t understand the technicality of why the below query would work when I run it from SSMS, but the same query fails when I add it as a job in the SQL Server agent.
I have an SQL Agent Job on a production server that keeps failing with the below messages. It is supposed to be capturing SQL Server activity using the SP_WHOISACTIVE stored proc, at regularly scheduled intervals.
The question: I am looking for a report that will display graphically what jobs are scheduled on the server and when. My goal is to very quickly be able to glance at it and find a time where a new job will not interfere with other jobs. I have been looking at the “Standard” reports … Read more
I’ve got several SQL Server Agent jobs that should run sequentially. To keep a nice overview of the jobs that should execute I have created a main job that calls the other jobs with a call to EXEC msdb.dbo.sp_start_job N'TEST1'. The sp_start_job finishes instantly (Job Step 1), but then I want my main job to wait until job TEST1 has finished before calling the next job.
SQL Server 2014 Standard Edition.
When I’m trying to start SQL Server Agent, I got this error:
Can someone please point me in the right direction. I keep getting the below error message when I try to run a job that executes a package I created and saved on the SQL Server.
Running a powershell script from SQL Server Agent in 2014 using my AD account via a credential. I am getting the following error.
I recently saw some kind of export of SQL jobs configured under SQL Server Agent that I would like to achieve as well.
Unfortunately I don’t have any trace to author of that report to ask himher about report creation, hence looking for help here as I had no luck googling it nor searching in here.