New post in Sql-agent-job

Automatically copy data from one table to another

June 16th, 2022

sql-server sql-agent-job sql

SQL Server Agent Adding a Parameter for a CmdExec

June 4th, 2022

sql-agent sql-server-2008 sql-agent-job

SSIS Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection

June 14th, 2022

sql-server ssis-2016 sql-agent-job sql-server-2016 ssis

Need to start agent job and wait until completes and get success or failure

July 20th, 2022

tsql sql-agent-job sql-server-2005

SQL xp_cmdshell copy files between servers

February 8th, 2020

xp-cmdshell sql-agent-job sql-server sql

The job failed. The job was invoked by user<user>. The last step to run was step1

July 9th, 2022

job-scheduling sql-agent-job sql ssis

SQL Server Agent - get my own job_id

July 9th, 2022

sql-agent-job sql-agent sql-server

I need best practice in T-SQL Export data to CSV (with header)

July 9th, 2022

csv sql tsql sqlcmd sql-agent-job

How to pass a parameter to a SQL Job that will execute a stored procedure

July 12th, 2022

sql-server sql-agent-job tsql sql-server-2008

SQL Agent Job: Determine how long it has been running

October 24th, 2020

sql-server sql-agent-job sql-server-2008 sql

How to Partition a Table by Month ("Both" YEAR & MONTH) and create monthly partitions automatically?

July 9th, 2022

sql-server sql-agent-job dynamic-sql partitioning sql

How execute exe file from sql agent or job?

July 9th, 2022

sql sql-agent-job c#

Run C# code inside a SQL Agent Job

June 11th, 2022

c# sql-agent-job sql-server