I have created SSIS package which is running successfully and dumping the data to the required place. But the same …
sql ssis job-scheduling sql-agent-jobI don't want to hit the database frequently based on page request, so I planned to create a xml file …
c# sql sql-agent-jobWhat I need to do is export data into CSV file using T-SQL. And I'm very confused about there are …
sql tsql csv sqlcmd sql-agent-jobI have the below code (only the portion that is needed) EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@…
sql-server sql-server-2008 tsql sql-agent-jobI am trying to move all .zip in a specific folder to another folder. the source folder is located on …
sql sql-server sql-agent-job xp-cmdshellCould you suggest please how to create SQL Server Agent job for a stored procedure that have 1 input parameter? The …
sql sql-server tsql stored-procedures sql-agent-jobI'm trying to Partition a Table by both Year and Month. The Column through which I'll partition is a datetime …
sql sql-server partitioning dynamic-sql sql-agent-jobI'm trying to create a job that will run based on the online status of a database. For example, step 1 …
sql-server tsql sql-agent-jobThe Scenario There are certain SQL Agent Jobs that are scheduled to run every few minutes throughout the day. There …
sql sql-server sql-server-2008 sql-agent-jobI need to export the data from a particular table in my database to Excel files (.xls/.xlsx) that will …
sql excel sql-server-2008 export-to-excel sql-agent-job