SQLServerCentral / SQL Server 7,2000 / SQL Server Agent

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

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

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

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

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?

SQL job fails when I schedule DTS through job

kanya.venkatappa — Fri, 16 Sep 2011 00:19:34 GMT

Hi Guys,I have a SQL job (SQL 2000) which runs the DTS (FTP the file) . When scheduled through job, it fails. But if I manually re-run the job, it runs successfully.Here is the job history : The job failed. The job was invoked by schedule 48. The last step to run was step 1(pull file from interface team through DTS)Note : SQLServer agent is running under N account. The job is also running under same ownership of N account.Any help will be much appreciated.Thanks in advance.

Shrinkdatabase job running via the SQL Server Agent

Irma Martis — Wed, 22 Jun 2005 07:57:00 GMT

We run via the Enterprise Manager (sql server 2000) a Shrinkdatabase job via the SQL Server Agent with the following statements:

DBCC Shrinkdatabase (xxx, 20)DBCC Shrinkdatabase (tempdb, 10)

The last couple of days I frequently got the following failed-message:

Executed as user: xxx. Could not adjust the space allocation for file 'xxx'. [SQLSTATE 42000] (Error 3140) DBCC execution completed. If DBCC printed error messages, contact your system administrator.[SQLSTATE 01000] (Error 2528) Associated statement is not prepared [SQLSTATE HY007](Error 0) Cannot shrink log file 2 (templog) because requested size (7256KB)is larger than the start of the last logical log file. [SQLSTATE 01000] (Message 9007) DBCC execution completed. If DBCC printed error messages, contact your system administrator.(Message 0). The step failed.

Can someone explain to me what's the problem we currently have?

Phantom Job

svwilliams01 — Thu, 11 Aug 2011 13:04:59 GMT

I am receiving the following error message from a job that no longer exists:EventID: 0x400000D0 (208) - SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan2 - Rotational DB'' (0x855E7AAA04C33B49A4D4CC8EB9439FAC) - Status: Failed - Invoked on: 2011-08-11 12:00:00 - Message: The job failed. Unable to determine if the owner (sa) of job Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan2 - UPS DB' has server access (reason: Unable to connect to server - check SQL Server and SQL Server Agent errorlogs). **** Local Message Creation Time: 08/11/2011 12:00:15The error message started appearing out of no where. I checked the jobs and it isn't there, it is an old job that was recreated with a different name.I have done the following:1. Deleted Maintenance Plan and recreated, when message continued I disabled the new transacation job and still get the errors.2. Stopped and restarted the SQL Server Job Agent.

SQL 2000 maintenance plan jobs hang on Step 1

webrunner — Wed, 07 Jan 2009 16:22:19 GMT

Hello,I noticed that starting on 01/02/2009, one of our maintenance plans started hanging. The server in question is running SQL 2000. The maintenance plan has these tasks:Backup Database (with removal of files older than 3 days; Simple recovery, so no log backups)Optimizations JobIntegrity CheckHere is what I know so far. Let me know if you need more information.1. The backup job runs every day in the late afternoon, while the other jobs are staggered to run every other day (one Monday, the other Tuesday, etc.) in the middle of the night. So I noticed the backup job behavior first.2. The job starts fine, and backs up all of the relevant databases - except for one, which I noticed is selected in the properties of the job but had not been backed up since 01/01/2009. I manually backed up the database, though, with the verify option checked, and the backup was created successfully.3. The backup job does not remove the files older than 3 days, and when I look at the Jobs section of the Management node in Enterprise Manager, the job status says: Executing Job Step '1 (Step 1)'.4. It looks like the job will remain in that state forever, unless I select the Stop Job command. When I first noticed the problem, the backup job had been in that state for 37 hours. Even though I noticed the backup job behavior first, eventually all of the jobs in the maintenance plan get stuck in the same "Step 1" manner.5. I tried creating a new job with the same settings, and disabling the old one, but I am getting the same behavior.6. We have other maintenance plans that perform the above tasks for other databases, and they are working fine, including cleaning up the files older than 3 days.Has anyone else seen this behavior? Does anyone know why the jobs would hang this way? Is it one database in particular out of the 10 or so involved that is causing the problem? If so, is there a way to find out which one? Also, is this a SQL 2000 issue? We are running this version:Microsoft SQL Server 2000 - 8.00.2050 (Intel X86) Mar 7 2008 21:29:56 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Thanks for any help - this is driving me crazy!webrunner

move SQL 2005 Maint Plan output file location

kob uki — Tue, 12 May 2009 14:13:43 GMT

Hi,I need to move every activity from a drive to another drive. All system and user dbs have been moved to the new drive, even the Agent log file location has been changed. My problem is that existing maintenance plan's output files are still being placed to the old drive.How do I change to location of those output files? I can't find the option inside the maint plans, system tables, registry. When we create a Maint Plan, we can specify the output folder for a backup let's say, but how do you change that afterwords?Any help would be appreciated.Thanks,Janos

Getting “EXECUTE permission denied on object ''sp_start_job''” when attempting to start SQLAgentProxy job on 2005

arnewman — Thu, 26 Oct 2006 03:49:00 GMT

Hi All, hope you can help - I am getting the following error when attempting to run a job through SQLAgent Proxy in SQL 2005:

"EXECUTE permission denied on object 'sp_start_job', database 'msdb', schema 'dbo'."

Steps I took to create:

1. Created a Credential 'SQLProxy_Credential' using a pre existing domain account (DOM\SQLProxy)

2. Created a Proxy 'SQLProxy' using the credential from above. Gave the following Activate permissions for the proxy: ActiveX,OS(CmdExec),SSIS packages

3. Created a local test windows account on server 'TestSQLProxy' Added to SQL Server with following Access to msdb: public SQLAgentOperatorRole Also public access to master

-- Added as a principal to the proxy 'SQLProxy'

4. Created a test job as a sysadmin user eg. BOB

5. Tested job as BOB - worked fine

6. Logged on as TestSQLProxy & tried to run job resulting in error above.

...have I missed something(s) fundamental?

Many Thanks in advance

Server Rent :: VoIPSwitch :: VOS3000 :: Mera MVTS :: Nextone :: Asterisk..With All Module + Dedicated server for Rent USD 140 with 24/7Support

link2desh — Thu, 07 Jul 2011 14:05:38 GMT

Hello Sir/Madam,I am from Link2DeshWe are one of the leading A 2 Z wholesale VoIP service providers in Malaysia. We are providing our best services all around the world...we can give you very high quality of service for almost every SwitchCurrently we offering Stable Voipswitch and VOS3000 For wholesale termination with all modulesIntel(R)Xeon(R)CPU E5620 @2.40GHz 2.40Ghz2 GB DDR RAM250 GB HDDwindows server 20035000 GB Bandwith per month1 GB UPlinkconcurrent calls support cc 300 + vos3000 cc 1500 +Voipswitch : 2.0.0.983VOS Version : 2.1.1.5Rent per month 140$Intel(R)Xeon(R)CPU E5620 @2.40GHz 2.40Ghz4 GB DDR RAM500 GB HDDwindows server 2003Unlimited GB Bandwith per month1 GB UPlinkconcurrent calls support cc 500 + vos3000 cc 3000 +Voipswitch : 2.985.0.119VOS Version : 2.1.1.5Rent per month 180 $Intel(R)Xeon(R)CPU E5620 @2.40GHz 2.40Ghz8GB DDR RAM1000 GB HDDwindows server 2003unlimited GB Bandwith per month1 GB UPlinkconcurrent calls support Vps cc 800 + vos3000 cc 5000 +Voipswitch : 2.985.0.119VOS Version : 2.1.1.5Rent per month 250$2 x Intel XEON E5620 8 x 2,4 GHz16 GB DDR RAM1000 GB HDDwindows server 2003unlimited GB Bandwith per month1 GB UPlinkconcurrent calls support cc 2000 + vos3000 cc 7000 +Voipswitch : 2.0.0.983VOS Version : 2.1.1.5Rent per month 300$Intel (R) Core (TM) i7 CPU 950 @ 3.07 GHz 3.07 GHz24 GB Ram 1.5 TB HDDwindows server 2003unlimited GB Bandwith per month1 GB UPlinkconcurrent calls support Vps cc 5000 + vos3000 cc 10000 +Voipswitch : 2.985.0.119VOS Version : 2.1.1.5Rent per month 350$NO SETUP FEE, NO CONTRACTS, JUST MONTH TO MONTH SERVICE.Symbian & Windows Mobile Dialer Available on Rent for All VoipSwitch AT $200/month.pc2phone ( 100% ) Workin VPN JAVA Dialer For Uae AT $200 one time installation charges| VOS3000 | Mera MVTS | VoipSwitch |Asterisk | ONE TIME INSTALLATION FEE $500please contact if you are looking for Stable | VOS3000 | Mera MVTS | VoipSwitch |Asterisk | for wholesale TerminationContact us for more informationyahoo : link2desh@yahoo.commsn : sales@link2desh.netweb : www.link2desh.netThank you Link2Desh

Could not load package "\File System\SSIS Packages\Package" because of error 0x80070002

montanamurf — Tue, 14 Apr 2009 22:56:30 GMT

Hi,My package will run using the SSIS Execute Package Utility, but will not run with a Job or through the xp_cmdshell EXEC xp_cmdshell 'dtexec /dts "\File System\SSIS Packages\Package"Error:Could not load package "\File System\SSIS Packages\Package" because of error 0x80070002.Description: Unable to find the specified file.Any help finding a solution for this is greatly appreciated.

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.

Proxy Account as member of the Local Administrator Group

richarddelcarmen — Tue, 31 May 2011 22:05:39 GMT

Hi guys,Is it required that the Proxy account of the SQL Server Agent be a member of the Local Administrators group?Because when its not, the job step fails to execute saying "DTSRun OnError: DTSStep_DTSCreateProcessTask_1, Error = -2147024891 (80070005) Error string: Access is denied."By the way, the job executes a DTS package.Thanks.

Error code:8152

vinu.kutty86 — Thu, 07 Oct 2010 11:48:59 GMT

Dear DBA's, If anybody knows the solution for this problem please share with us.:doze:

Error: Unable to post notification to SQLServerAgent

David Poduska — Wed, 07 Apr 2004 08:48:00 GMT

I'm running SQL Server 2000 and this morning started receiving the following error when attempting to manually run jobs:

From Microsoft SQL-DMO (ODBC SQLState 42000)Error 22022: Unable to post notification to SQLServerAgent (reason: MapViewOfFile() returned error 8, 'Not enough storage is available to process this command.')

It is only jobs started manually that have a problem, scheduled jobs run fine. The server has 2.5GB of RAM. A total of 2GB of RAM is in use with SQL Server using 1.8GB, so there is plenty of memory available. The disk drive with the least free space has 4GB free.

I don't know if they are related (but I suspect they are), but earlier this morning we also started getting the following error when attempting to send mail via CDOSYS:

Error setting Message configuraton field "smtpserver". [SQLSTATE 01000] (Message 0) ODSOLE Extended Procedure [SQLSTATE 01000] (Message 0) Error loading type library/DLL. [SQLSTATE 01000] (Message 0).

The database configuration has not changed recently and I'm at a loss as to what the problem could be. Any help is greatly appreciated.

Thanks,Dave

SQL Server Agent Jobstep predecessor on a different SQL Server

Libby — Wed, 18 May 2011 08:15:38 GMT

Does anyone know if it's possible to create a job on one 2008 SQL Server that should not run until a job on a different 2008 SQL Server completes? This is the situation: Server A has a job (I'll call JOBA) on the SQL Server Agent that runs several steps which do some normalization activities to tables on Database A.Server B is a replicated server which contains Database A plus Database B, which is not on Server A. I need to create a job (I'll call JOBB) on Server B that updates tables on Database B, but reads data from tables on Database A after they've been normalized. We already have linked server setup to Database A on the replicated Server B. How would I make the job on Server A a predecessor to the job on Server B? Would there be a way to somehow have the JOBA update a table (last step) when it completes the normalization steps. Then the step in JOBB would run after it verifies the table update has been performed. Or maybe there's some other way to do this? It would be nice if we had scheduling software in our shop, but we don't.Thanks in advance for help anyone can provide.

SQL Server Agent - Log File Viewer

steve.clarke-1124563 — Wed, 18 May 2011 04:14:58 GMT

Hi all,After checking my SQLSA Job - I have noticed that it had been failing - so went to look into the Error Logs - but says under progress that "Unicode File Expected" and does not display ;Am I looking into the correct place to identify why the job is not running ?Thanks in advanceSteve

Troubleshoot failed SQL server agent job with backup file copied to the destination

DBAsql-1046554 — Fri, 15 May 2009 05:03:36 GMT

Hi,In SQL server agent i had scheduled a backup job to run on daily basic.It will place the copy of the backup file in the destination that i specified.The job history says that the job failed.But i can find the backup files copied to the destination.I need to know how the backup was copied to the destination even if the job failed?The log doesn't provide much information.Thanks.

Jobs fail after changing User account of SQL Server Agent

Basket-dan1 — Thu, 21 Apr 2011 08:50:51 GMT

Hello,I have problems with jobs that were started by the SQL Agent on SQL Server 2008R2 since i have changed the used SQL Server Agent User for all instances to different users. I have followed this website http://msdn.microsoft.com/en-us/library/ms143504.aspx to give the users the appropriate rights. I have also used this site for help: http://blogs.msdn.com/b/varun_sharma/archive/2007/08/30/how-to-run-sql-server-agent-and-sql-server-jobs-with-least-privilege-in-sql-server-2005.aspxAfterwards the SQL Server Agent has started on all instances. But there are still several messages about failed jobs. I checked the Windows Application Log, got the message "package...failed" (eventID 12291). Or in the history of the job, got the message "The job failed. The Job was invoked by Schedule 4 (CollectorSchedule_Every_15min). The last step to run was step 2 (collection_set_2_upload_upload)."I think that there still must be a permissions problem. Almost all jobs are collecting information of the databases in the instance and they are uploading the data to the standard MSSQLServer instance. But even in the standard instance the job fails.Now i don't know whether I have don’t set all needed permissions, or do I have to change s.th. on the roles of msdb (I’ve read that it should be done, maybe?) or do i have to make credentials/proxies so that the jobs work well again?thank you for your help.

SQL Server 2000 job stuck every alternate day

kanya.venkatappa — Tue, 19 Apr 2011 22:19:53 GMT

Hi All,One of the job in SQL Server 2000 stuck every alternate day. I had to re-run it every alternate day. Please let me know the

SQLSTATE 42000] (Error 22029) message

tt-615680 — Thu, 31 Mar 2011 04:55:33 GMT

Hi All,I am trying to run Integrity Checks Job for DB Maintenance Plan 'Delta Maintenance Plan' job and I keep getting the following error message:sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.I have looked under job history but I don't seem to find anything on it, would someone please let me know what this means please.Thank you

Scheduled Job fails with Process Exit Code -1073741819

rykchiu — Tue, 15 May 2007 04:14:00 GMT

Dear all,

I'm at my wits end with this problem, so any help/advice is greatly appreciated.

Random steps within scheduled jobs are intermittently failing with the following message: "Executed as user XXX. The step did not generate any output. Process Exit Code -1073741819. The step failed."

I've checked/verified that all permissions are in place to run the steps. There is also nothing in the application or system event logs.

Best regards

master.dbo.xp_sqlmaint N'-PlanID

todd_dawson — Tue, 02 Sep 2008 13:33:09 GMT

How can I find the PlanID for a Maintenance plan that I created?I am trying to setup a job under the Agent, but cant find the PlanID and exactly how to execute the plan successfully.I am guessing after finding the ID I can just enter an EXECUTE.... as a T-SQL statement.Is this how it is done in all of SQL2000?