Question : I have a weekly and nightly SQL Server Agent jobs executing a weekly and nightly maintenance plans, resp. […]
Tag: sql-server-agent
How to use sqlcmd to create file names for output based on the day of the week or the date?
Question : I have a SQL agent job that queries the database and exports the results into a csv file. […]
SQL Server create cron job without SQL Server Agent
Question : I’m creating a cron job on SQL Server. As per my knowledge, the only way possible to create […]
SQL Server Agent cannot log on to “MyServer”
Question : I’m struggling to get our SQL Server Agent to run a maintenance plan, which used to work in […]
SSIS unpivot returns different results when run via a SQL agent job
Question : I hope someone can help me. I have an SSIS package which grabs data from an excel (.xls) […]
How to move a SQL Agent Job to another Server?
Question : I’m moving from SQL Server 2005 to SQL Server 2008R2, and I see there is one job in […]
Agent job will not run
Question : I created a JOB to run a simple package that runs a query and saves the results to […]
Datepart logic for custom sql agent job schedule
Question : Wanted help in code for below logic. Job A needs to be run on 8th of month. Job […]
Stop agent job after executing for a certain number of hours
Question : I have a scheduled job which runs nightly. I want it to stop itself at 07:00AM in the […]
SQL SERVER Detailed Backup Report
Question : I need to create a script that gives the report for the following information: Backup Job Name Databases […]