Question : I have a job on server B, which is linked to server A. Is it possible to disable […]
Tag: jobs
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 […]
Script to Add a Job to a SQL Server DB
Question : I want to add a job to my DB to make a back up weekly but i want […]
Agent job will not run
Question : I created a JOB to run a simple package that runs a query and saves the results to […]
On what basis is the sql job’s step linked to a database?
Question : I have couple of SQL jobs on source sql server, and on the job step a particular database […]
Maximum Error Count Reached
Question : I created a maintenance plan to backup all the databases locally on a folder in E Drive. Out […]
Specify Server for DBMS_Scheduler Job in Policy Managed RAC
Question : A unit test requires a dbms_scheduler job to run on the same RAC node as the unit test […]
Backup Only Database Schema Everynight
Question : I have an instance with 15 databases on SQL Server 2012. I will set up to backup system […]
how to check who has killed the job which was running ?if logs are not generated
Question : Unspecified error occurred on SQL Server. Connection may have been terminated by the server. This is error I […]
What’s the best way to pass a variable/valuable between steps in a SQL Server job
Question : For example, if I create a dtsx package that fills out an excel sheet, but only email it […]