SQLServerCentral / SQL Server 7,2000 / SQL Server Agent

SQL Job Timeout

blurrytextfile — Wed, 17 Apr 2013 10:17:34 GMT

I have a stored procedure that gathers information about index health and inserts it into a table. The query is joining [b]dm_db_index_physical_stats[/b] and [b]sys.indexes[/b]. The database contains 2800 tables, so the operation takes 90+ minutes to complete. But it completes successfully when executed using SSMS.However, a job created to execute the stored procedure fails every time, after about 14 minutes. The error is:"The semaphore timeout period has expired. [SQLSTATE 08S01] (Error 121) Communication link failure [SQLSTATE 08S01] (Error 121)."My question: why would the operation fail, and why timeout so quickly, when executed from SQL Agent? Yet, the same operation is successful when run manually?

Monitor High CPU

nadersam — Mon, 20 Feb 2012 04:40:32 GMT

Hi All,I created an alert under sql server agent alerts.I selected type as sql server performance condition alert, Object:Sql server :Resource Pool Stats,Counter :Cpu usage %, Instance:default,Alert if:Counter rises above 40.I made response trigger running a job and notify database operator using email.I ran some sqls to trigger high CPU usage but the alert is never triggered and nothing happens!!.Looking forward for your feedback.Nader

cmdexec step running and not doing anything

dkhattar — Tue, 19 Jun 2007 02:59:00 GMT

Hi,

I have a job in which one step is of type cmdexec, Agent history shows the step ran successfully with duration is 00:00:00, where as nothing was executed from the BAT file. If I run the step manually it works fine but when it is executed through it runs successfully without really executing commands of batch file. This job was running fine for over two years.

I restarted the Agent it started working fine.

Its on sql 2000 with sp3a.

What could be the reason?

Thanks

Deepak

Sql Server 2000 Notification error

solomon.jernas — Tue, 15 Jan 2013 06:56:52 GMT

I am getting error ,when i click the operator to send to mail ... "Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent Properties dialog."I am using sql server 2000 sp 4 and windows 2000 server ..Please anyone help me.. Note: it is running last year 2012, after that they changed exhange server to cloud , it is coming error..thanksJery

error agent job : error loading a task

fatinfzi — Sun, 13 Jan 2013 21:39:53 GMT

Anyone have an idea why this maintenance backup failed?All rights reserved. Started: 3:00:00 AM Error: 2013-01-01 03:00:14.14 Code: 0xC0010018 Source: Back Up Database Task Description: Error loading a task. The contact information for the task is "Back Up Database Task; Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. End Error Progress: 2013-01-01 03:00:14.72 Source: {D49EC6E3-5390-46F6-9FB1-91BDAD937D3A} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2013-01-01 03:00:15.16 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_create_subdir N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\... The package execution fa... The step failed.Thank you in advance!

SQLServerJob failing

eirik.andersen — Thu, 09 Aug 2012 02:55:08 GMT

I have a job that executes fine most of the time but sometimes it fails with the error below. The service for SQLServerAgent is logging on with a windows account and the job is owned by sa. The job has one step executing a maintanenceplan with the following code EXECUTE master.dbo.xp_sqlmaint N'-PlanID 80CB4BBB-AF15-4C7E-AD3B-02CCA9B6F85B -To "Remote DBA" -WriteHistory -BkUpMedia DISK -BkUpLog "Folderpath" -DelBkUps 3DAYS -BkExt "TRN"'The view history for the job shows the error:Executed as user: DOMAIN\user. ConnectionCheckForData (CheckforData()). [SQLSTATE 01000] (Message 10054) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed.The log for SQLServerAgent shows two errors:1. [382] Logon to server 'SERVERNAME' failed (ConnAttemptCachableOp)2. [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]The output from select @@version is:Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) We have 3 servers one with SQL Server 2005 and two with 2000. The same error occurs in the SQLServerAgent log on all the servers but are very rare on two.

How to migrate sql scripts from 08 to 05

@ry@n — Tue, 25 Dec 2012 23:04:16 GMT

[font="Times New Roman"]Hi,We have developed some scripts in SQL Server 2008. Now, we need to migrate them to SQL Server 2005.Should i generate database script (for all its objects by SSMS GUI) after setting the compatibility level to 90.Is this the right way to do it...will it work fine...is there any other way to get is done..Your comments plz Warm Regards,Anil KMCTS[/font]

no replicated transactions are available

dyun — Mon, 22 Aug 2005 13:23:00 GMT

I am replicating data to two different subscripton databases from the same publisher DB. One subscription works fine while the other shows 'No replicated transactions are available' with no error messages. The subscription that has the issue is also the distribution. Any feedbacks will be highly appreciated. Thanks.

[442] cryptunprotectdata failed (13)

puttuseenu.murthy — Mon, 26 Nov 2012 10:07:38 GMT

Hi All,Could you please help me out to find the solution for below mentioned problem.when i try to add subscription on merge replication. after creation of subscriber i am getting below error "The job failed. The Job was invoked by User sa. The last step to run was step 1 (Run agent.) " and when we view job history below error is displaying"[442] cryptunprotectdata failed (13)"ThanksSrinivas.

grant permissions to view SQL Server agent.

striker-baba — Fri, 02 Jul 2010 08:32:54 GMT

Hi all,I am not able to see the sql server agent.But, when I login as a sysadmin I am able to see.Can anyone help me on how to provide read access to sql server agentso that when I logon as a datareader I need to be able to view SQLserver agent.Only read or view permissions.Thanks .

Please Help Solve Why SSIS Package Fails When Run as SQL Agent Job

fellmeth — Wed, 24 Nov 2010 12:44:20 GMT

We have SQL Server 2005 x86 locally. On it we have a SQL Agent Job that runs an SSIS package in MSDB that loads source from a local Access 2007 DB to a destination of remote SQL 2003 x86. This Job has been and continues to work just fine.We are now trying to run the same Job to a destination of remote SQL 2008 R2 x64, and the Job keeps failing. The package runs just fine from VS and MSDB. But when it's added to the Job, it fails with following error from log. Help much appreciated.11/24/2010 14:37:42,Daily Website Update,Error,6,SQLSRV,Daily Website Update,BOOKS Table VPS,,Executed as user: DRAMATISTS\svcsql. ... Utility Version 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:37:42 PM Error: 2010-11-24 14:37:42.57 Code: 0xC0202009 Source: BOOKS Table VPS Connection manager "DestinationConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2010-11-24 14:37:42.57 Code: 0xC00291EC Source: Preparation SQL Task Execute SQL Task Description: Failed to acquire connection "DestinationConnectionOLEDB". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:37:42 PM Finished: 2:37:42 PM Elapsed: 0.469 seconds. The package execution failed. The step failed.,00:00:00,0,0,,,,0[/color][/color]

sql server maintenace jobs schedule at 10 am not executing

naga.rohitkumar — Tue, 25 Sep 2012 23:36:40 GMT

HI to all can any one guide me in this sql server maintenace backup jobs schedule at 10 am not executing It is continuesly in the executing state and i manualy stoping and executing daily in whicc conditions it will happens and what is the solution for it

Ideas welcome on SSIS jobs, Agent and kicking off another SSIS job

chris.stuart — Tue, 14 Jul 2009 04:42:50 GMT

Hi.I'm looking for some ideas. Currently I have 3 SSIS packages which are scheduled in SQL Server Agent. The run every 10 mins, and updates the DW. The first step in all 3 of them is to check if the latest flat file is in a directory, if not quit, else load the data into the DW, easy.All 3 packages runs every 10 mins, first 1 on every 10 th min, second on the 11th min and 3 on the 12th min.The packages can execute for an empty file in a few seconds, for daily data a few mins, and at the start of the month even a few hours. All 3 packages runs in parallel.The requirement now is for me to provide data to a validation system which will be used when the mainframe is down. The table which I’ll populate is on a different server, but the table is self will require data from all 3 tables which is updated via the 3 packages.So, therefore I need to make sure of the following:1) That the 3 packages have finished successfully2) That there is new data to be inserted to the validation table.What would be best way be of achieve this?

How can i make the data transformation in DTS to do an update instead of insert?

Carlaabanes — Tue, 14 Aug 2012 02:04:22 GMT

Hi guys,this is the dilemma im in now. i have to create a DTS package that instead of doing the usual copy columns in data transformation, i need it to perform an update statement instead. Any ideas on how i should move forward with this??appreciate for any replies..TIA

SQL Agent Job Hangs

navis59 — Thu, 06 Sep 2012 13:16:35 GMT

Hi All,I tried to run a job which pulls approx. 90 GB of data. When I saw it stuck for 7 hrs at one step I tried to stop it. I don't see it running on my screen but my DBA told that it's still under cancelling mode on server. It has locked my table. Don't know what to do? I am using SQL Server 2008 R2

Creat one sql job on 4 different environments same time in one script

himanshuk — Thu, 30 Aug 2012 05:48:24 GMT

--I need to know codes for GO TO NEXT STEP, and need to replace with script below--also I want to just fill it as per requirememt and increase steps if more than 1 --can anyone customise better as far as schedules are concern that what I have done, thanks in advance[quote]USE [msdb]GOBEGIN TRANSACTIONDECLARE @ReturnCode INTSELECT @ReturnCode = 0IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)BEGINEXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]'IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollbackENDDECLARE @jobId BINARY(16)EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N'JOB NAME FROM TXT FILE', --JOB NAME @enabled=1, --keep it 0, just deployed, as per requirement we can make it 1 so that alert mails can avoided @notify_level_eventlog=0, @notify_level_email=0, @notify_level_netsend=0, @notify_level_page=0, @delete_level=0, @description=N'SOME DESCRIPTION IN TXT FILE', --DESCRIPTION @category_name=N'[Uncategorized (Local)]', --CATEGORY--Logins 4 environments --can I make like below so that on 4 environments at a time this script will execute??--Stage @owner_login_name=N'CORP\StaSQLExec', --DEV @owner_login_name=N'CORP\DEVSQLExec'--CT @owner_login_name=N'CORP\CTESQLExec' --RT @owner_login_name=N'CORP\EXTSQLExec' @job_id = @jobId OUTPUT IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback--Steps EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'step name from txt file', --step name -step1 from txt file --Step 1 -- @step_id=1, --if more than step 1 then repeate block @cmdexec_success_code=0, @on_success_action=1, -- make it 2 @on_success_step_id=0, @on_fail_action=2, @on_fail_step_id=0, @retry_attempts=0, @retry_interval=0, @os_run_priority=0, @subsystem=N'SSIS', @command=N'/SQL "\DTS NAME FOR STEP 1" /SERVER npkstadat11 /CONFIGFILE "E:\SSIS_Package_Repository\DTS NAME FOR STEP 1\PackageDependencies_20120801\DTS.dtsconfig" /CHECKPOINTING OFF /REPORTING E', @database_name=N'master', @flags=0--Step 2 -- @step_id=2, --if step 3 then repeate block @cmdexec_success_code=0, @on_success_action=1, -- what is GO TO NEXT STEP code here?? @on_success_step_id=0, @on_fail_action=2, @on_fail_step_id=0, @retry_attempts=0, @retry_interval=0, @os_run_priority=0, @subsystem=N'SSIS', @command=N'/SQL "\DTS NAME FOR STEP 2" /SERVER npkstadat11 /CONFIGFILE "E:\SSIS_Package_Repository\DTS NAME FOR STEP 1\PackageDependencies_20120801\DTS.dtsconfig" /CHECKPOINTING OFF /REPORTING E', @database_name=N'master', @flags=0IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollbackEXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollbackEXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollbackEXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'JOB NAME', @enabled=0, --keep 1 so that alert mails can be avoided @freq_type=8, @freq_interval=127, @freq_subday_type=1, @freq_subday_interval=0, @freq_relative_interval=1, @freq_recurrence_factor=1, @active_start_date=20080318, --start date @active_end_date=99991231, -- end date @active_start_time=91500, @active_end_time=235959, @schedule_uid=N'a4c6128a-c053-4041-bb07-53012cee1527' -- what can we put here?IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollbackEXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollbackCOMMIT TRANSACTIONGOTO EndSaveQuitWithRollback: IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTIONEndSave:GO[/quote]

Timing out scheduled jobs

hugo r — Thu, 05 Nov 2009 10:58:51 GMT

I asked this question in another forum and unfortunately I still do not have an answer. This is the problem:I have several scheduled tasks that run every 10-30 seconds. All this tasks run very well, they take in the worst cases 2 seconds to run, but usually is less than a second (History shows 00:00:00), when I run them in SQL they are almost instantaneous too, so everything is fine... Except there is one of this tasks, which connects to an Oracle Linked Server (there are two more that connect to the same oracle database, other tasks connects to Sybase and yet other tasks connects to old foxpro tables, but those are not the issue) that once or twice a day decides to keep the query running ad-infinitum. Only way to stop it is to restart the SQL Server Agent, and then it runs smoothly for some time.My first thought to fix this problem is to limit the running time of the Jobs, lets say if they take more than 5 seconds then just cancel it and try again the next scheduled time, unfortunately I am not able to find information of how to do it (my google skills are not up to par this days it seems!), is it possible to do it? And how?I know it would be better to find the causes of this instead of treating the symptoms, but I thought it would be useful to have something like this anyways for all the scheduled jobs, so one can analyze the logs and when there are jobs that are "timing out" then one can try to find the problem without the need to stopping the job while investigating.I looked at several time out settings, like Connection Timeout and Query Timeout for the linked servers, they do not end this query (it is actually a simple dynamic SQL that reads data from the remote table(s) and insert record(s) in local table(s)) and the problem is always with the same job, the others run without problem even the others that are using the same Oracle Linked Server.Now I am thinking of having yet another job that checks the job history and re-starts the Agent service if it notices a big gap on them. (By the way, restarting the agent is the only way to stop that query)Any help would be much appreciated, thanksHugo

Agent Job failing with FTP task In SSIS package

rjdineen — Wed, 04 Apr 2012 06:43:20 GMT

Good afternoon everyoneI have a SSIS job that uploads file to FTP that works fine via SSIS.I have the protection level set to EncryptSensitiveWithPassWordI have deployed the package to sql server. when logged into Intergrated Services via SSMSwhen i run the package, enter the password it works fine. But when i setup an agent job and then run that. The package itself runs. but it fails at the FTP task.what else can i check.Kind RegardsRob

SQL Agent Job "hangs" due to a wait type PREEMPTIVE_OS_PIPEOPS

SMAAG — Wed, 14 Oct 2009 11:47:54 GMT

We have a custom back end process we use to process batch jobs asynchronously through a queuing table. Many of the jobs that are executed in this process run through a stored procedure that executes a SSIS package using the xp_cmdShell. Originally, these were DTS packages in SQL 2000 and 2005 which executed using the dtsrun executable. Recently we upgraded to SQL 2008, migrated the DTS packages to SSIS 2008, added a cluster to the mix, upgraded to Win 2008, and are running in a 64 bit environment. The SP still executes the packages via xp_cmdshell but now uses the dtexec.exe (32 bit version). About 90% of the time we have no issues. However, in two instances we have had the SQL Agent job "hang" due to a wait type on the xp_cmdshell. The wait type is PREEMPTIVE_OS_PIPEOPS. Each time we have tried killing the spid, however, this created a rollback that appeared could take hours to complete. The only way to release the pressure and allow users to process again was to fail over the cluster to another node. The resolution here is not a long term fix obviously. I'm currently trying to determine what is causing this wait type, how to prevent it, etc...I'm leaning toward a concurrency issue and considering making the process run single threaded to try and avoid this. However, since this was never an issue in our SQL 2005 / Windows 2003 environment leaning toward an issue with our new environment.**Our environment is SQL 2008 but unable to find a forum for the sql agent in the 2008 forums so I posted it here for now.

Create SMS notification for SQL server 2008 R2 agent Alerts.

subhaoviya — Wed, 11 Jul 2012 03:54:58 GMT

Hi, I able to find two notification options for SQL Server agents as Email, Pager and Netsend. I am having requirement to do the Telephone and Mobile notifications. Can anyone please help me to do this task.

last backup date query

harriet.louis — Tue, 09 Jun 2009 06:31:53 GMT

Does anyone know how SQL Server Management Studio knows when the last backup took place? The specific query I am looking for is the the one that would populate the properties page if you right click on a database and select properties. preferably this query will have nothing to do with sysjob tables, as I am trying to avoid working with these...:hehe:

SSIS Package runs via SQL Agent but not via scheduler (IBM Tivoli)

kmmcleod — Tue, 05 Jun 2012 11:11:09 GMT

I just migrated my Database and SSIS packages from an old server running SQL 2005 to a new server running SQL 2008. Now, my SSIS packages are running successfully via SQL Agent but are failing when run via our Scheduler (IBM Tivoli/Maestro). Has anyone ever seen this before? Thanks for any ideas / suggestions.

Please help me (Date Difference Issue)

mota7128 — Wed, 16 May 2012 10:02:49 GMT

Hi All,can you please help me to get the difference between 2 dates, I need the result to be in hour and minutes onlyI tried DateDiff() function and datepart() and everything I know but didn't give me the needed dataFor Examplefirst date (Monday 2012-05-14 12:07:00.000)End Date (Tuesday 2012-05-15 15:40:34.497)working hours starts at 8:30 am and ends at 5pmso the difference should be 4hr:53min + 7hr:10min = 12hr:07minPlease guys help me.Thanks,Hatem

Can't find SSIS package in the job drop down list! please help

mota7128 — Fri, 20 Apr 2012 09:37:29 GMT

Hi, I have created some SSIS packages and they are working well on BIDS, I uploaded them to Inetgration server, and when I went to SQL Server Agent to create a new job, and added new step to read from the uploaded packages, I couldn't find the "SSIS Package in the TYPE drop down list .please help me, what can I do to add this option? Please have a look on the picture on this linkhttp://www.mediafire.com/?w7tof6lpzf61ednAny help will be highly appreciated.Thanks,Hatem

Unable to view SQL Server Agent while logged in

Candls — Wed, 27 May 2009 12:54:53 GMT

Hi All,I have asked the DBA to grant me access to SQL server agent so I can view jobs, but this seems this can't be accomplished. I have Microsfot SQL server management studio 2005. Does anyone know what config and/or installation is required to be able to view SQL Server agent?

agent job failing with two steps

rjdineen — Wed, 04 Apr 2012 06:46:09 GMT

Hello everyoneI have an agent job with two steps,when i run the top step it completes with the second not running at all.But if i run the agent job specifing the second step to runThat also completes. Is there something obvious i can check?Kind RegardsRob

Job fails due to execute process task on sql server agent

jasminipatel51181 — Wed, 21 Mar 2012 21:15:16 GMT

Hi , I have an issue with the SQL Server Agent job . My Package runs fine on BIDS but fails when I schedule it . Error Message on Job: 1. Error Code : 0xC002913 Source : ReName Knewton’s file Execute Process Task Description : File/Process “Knewton.bat” does not exist in directory “C:/users/jpatel/Batch files/Knewton.bat” 2. Code : 0xC0024107 Description : there were errors during task validation. Please provide me any solution as soon as possible .Thanks,J

How can I disable a Job via TSQL

Paul Paiva — Tue, 10 Oct 2006 09:42:00 GMT

I want to do an upgrade on a busy SQL 2000 server that has lots of jobs kicking off at different times. But first I need to wait until there are no jobs running before I shut down the SQL Agent.

My plan was to make a copy of sysjobs, then I did

UPDATE sysjobs SET Enabled = 0

To my surprise the jobs kept executing. When I queried the table, sure enough the Enabled column (smallint) was all zeros. I'm thinking the Agent must have a cache somewhere which needs to be refreshed, but I don't know how to do that.

Any ideas on how to disable my jobs via TSQL?

Thanks

Paul

agent blocked and jobs at status: Executing: 0 (unknown)

darko IS — Sun, 10 Jan 2010 15:13:27 GMT

hi,We have SQL SERVER 2005 RTMWe have 10-15 jobs, some of them are called from store procedures, some are scheduled and some of them are running for hours.suddenly i found out that some jobs are running for 2 days and they have status Executing: 0 (unknown) . When i try to stop them i get error messages:[i]Stop failed for Job An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)Unable to post notification to SQLServerAgent (reason: The maximum number of pending SQLServerAgent notifications has been exceeded. The notification will be ignored.) (.Net SqlClient Data Provider)Error Number: 22022Severity: 16State: 1[/i]I don't see any locks, deadlocks or any other performance issue. I went to error log file viewer and found out there was lot of warnings like:[i][000] Request to run job xyz (from User xyz) refused because the job already has a pending request from User xyz[/i]We are going to restart SQL SERVER Agent service, but does anybody know what could be the reason for this? any ideas?

Calling SSIS from SQL Server Agent Doesn't Run No Error Given

Margaret Norkett — Thu, 29 Jan 2009 09:32:15 GMT

I call an SSIS package with a SQL Server Agent Job. The first "step" in the SSIS package is to move files from one folder to another. This step never executes. The next tasks are to generate a new file and ftp that file to a location. This part seems to work.Why isn't the first task executed from the SQL Agent job? This job never reports an error.:w00t:

Starting SQL server - error 1068 and error 193

vinitjain — Tue, 22 Mar 2005 14:58:00 GMT

Hi,

I am trying to start the sql server aganet from services and its giving me an "1068 - the dependency service or group failed to start"

I have read numerous posts on this error and everyone suggests that chaing the logon to local system account will solve the purpose. I have tried that many times buts its working.

When i click the start button from sql server agant interface, it gives me an error "%1 is not a valid win32 application "

Any takers of this problem ??

One more thing .. when i run the mssqlserver service i get -error 193 -ocx1

Pls help

ThanksVinit

Alert 014 insufficient permission

EA — Thu, 06 Jul 2006 08:23:00 GMT

I've created several alerts, it seems to be working correctly.

But .... why is alert 014 (SQL Server event alert, severity 14 insufficient permission) raised when a succesful connection is made?

I get the message "Login succeeded for user "domain\user". Connection: Trusted.

This is not an insufficient permission? Why is the alert raised?

Any help or suggestions is welcome!

Script For Monitoring State of other servers and alerting !!!

bobnysoftz — Tue, 20 Dec 2011 07:42:53 GMT

Please can you help I need a script that will use a centralized server to monitor other sql servers state and if a server is offline it will send a email to alert the dba about which server has a database that is offline . Pleaase do great assist and all your help is greatly appreciated.

Configure SQL Server Agent Job to run Crystal Report

mickielsmith — Tue, 13 Dec 2011 09:58:35 GMT

Hey Forumers,I am doing research to see if SQL Server Agent Job can run Crystal Report. I found out my company does not have the Enterprise Edition of Crystal 2008 which has a free job scheduler. We have the Standard Edition. So, I am trying to see if there's an alternative which will not cost anything. Any suggestions, please offer an example for I can follow and be on the same page with you, thanks.

Get the executing Job that targets the local server

richarddelcarmen — Thu, 21 Jul 2011 21:53:48 GMT

Hi guys,There is a job in a remote server that targets the a database in the local server. The job truncates and imports data to the tables in the local database.I want to get the information about the executing job like the job name, host name, login used to connect to the server, etc.Is this possible?

Using batch file to stop & start SQL 7 - not working

jackie_chambers — Wed, 07 Dec 2011 08:26:50 GMT

I am using this : net start mssqlserver net start sqlserveragent in a simple batch file to start (and stop) both SQL 2000 and SQL 7 in order to do a backup of the db files. It works fine on the 2000 but does not work on the SQL7. Is there a difference I am apparently not aware of? The Arcserver program is running the batch files before and after the backup job.ThanksJBC

SQL AGENT JOB - VBScript

dankwart menor — Tue, 22 Jan 2008 03:53:42 GMT

Hi Folks!My Problem is that I executed a VBScript as an SQL Agent Job and somehow it only runs in background. I can see it in the task manager (with an owner that is the same user that is logged in). But it's invisible! It's not even in the task bar.I tried:[i]" Set ShellWSH = CreateObject("WScript.Shell") ShellWSH.Exec("notepad.exe") Set WshShell = Nothing" [/i]I also tried (same result):[i]" Set shell = CreateObject("Wscript.Shell") shell.Run "notepad.exe",5,True Set shell = Nothing"[/i]What can it be???Thx 4 reading, hope YOU might be able to help me out of that misery!-->Dankwart

Job that uses dtsrun is not working now

Stringzz — Wed, 02 Nov 2011 12:46:59 GMT

I have a few jobs that are using the CMDEXEC to run DTSRUN and start a package. These jobs worked fine up until a few days ago. Now the job runs in 2 secs with no errors and these packages take an hour or so to run.I remote desktop into server and run the same command line in CMD and it starts and finishes in 2 seconds. The actual packages run fine if they are ran as a package within Enterprise Manager.Any ideas what could all the sudden cause these jobs to work correctly?[sub]C:\Documents and Settings\TEMP>DTSRUN /S FTWBIOLAP02 /E /N AutoOCRVerifyImportDTSRun: Loading...DTSRun: Executing...DTSRun: Package execution complete.[/sub]

SQL Server Agent stops and cannot start

Lester Policarpio — Mon, 08 Oct 2007 03:53:42 GMT

My SQL Server Agent stops and cannot be started when viewing the error logs it displays the following errors:[b][298] SQLServer Error: 18456, Login failed for user 'NT AUTHORITY\SYSTEM'. [SQLSTATE 28000] [/b][b]000] Unable to connect to server '(local)'; SQLServerAgent cannot start[/b][b][098] SQLServerAgent terminated (normally)[/b]tried starting using the Services in control panel but to no avail what could be the problem? dunno what errors are saying.... There are no errors written in the event viewer only in the SQL Server Agent Error Log although this happened in my dummy database (testing server) i want to know what happened in my SQL Server agent

View ALL job History

SQL08Kid — Wed, 12 Oct 2011 07:54:03 GMT

It seems a while back I had a script that showed me all job history EVER on the server. I know I can view the job history for the amount of time I've specified in the job history log but is there some way to view job history for a job since the job was created?