I am trying to convert the dts pkgs in 2000 to SSIS 2005. Currently the db has a whole bunch of dtspkgs, not all are in use.
I want to be able to converted only the ones that are in use.
1. Is there a way to know which dtspackages are being used in the sqljobs?
2.Is there a way to quickly list the last time THE DTSPACKAGES WERE EXECUTED?
Hi:
Due to space issue, I temparaly disabled all Sunday backup jobs through set enabled =0 and it worked.
Now, I need to reactivate them via:
"update sysjobs set enabled = 1 where name like '%7Sun' and enabled = 0"
Though the enabled column becomes "Yes" in enterprice manager jobs section, but the NextRunDate is still the date I truned off.
Then I tried to update the sysjobschedule.active_start_date which is the NextRunDate to 20040206. after refresh the EM's Job section, the nextRunDate not change, but via edit the schedule found the start date is 02/06/2004. It looks 'distroy' something is really much easier than 'rebuild' something...
Any idea?
thanks
-D
Recently we renamed one of the SQL Server 2000 Server from NAME1 to NAME2. In the msdb..sysjobs table the originating_server name is still the old name ( NAME1 ). As SQL server 2000 suports multiple instanaces it will not rename it back to local.
So my Question is If I update the sysJobs table's Originating_Server Column to the new Server Name ( NAME2 ) . Will I have any issues. Because I not able to make any changes to the Jobs as it throws an 14274 Error. I don't want to rename the server back to the original name and do all the process as its given in the MSDN Article.
Thx
Venu
Hi,
When I am trying to drop a user using following statement
--First remove access from all databases
Set @SQL =
'
USE [?];
if ''' + @login_name + ''' in (Select name from sysusers )
EXEC [?].dbo.sp_revokedbaccess @name_in_db = N''' + @login_name + ''';
'
Exec sp_msforeachdb @SQL
Print 'Access Removed.'
exec @ret_value=master.dbo.sp_droplogin @login_name
I am getting an error,
User has been dropped from current database.
User has been dropped from current database.
Access Removed.
No permission to access database 'model'.
Server: Msg 229, Level 14, State 5, Line 1
SELECT permission denied on object 'sysjobs', database 'msdb', owner 'dbo'.
Login dropped.
The SQL Version I am using is
-------------------------------------------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Please help me to solve this issue.
Mujeeb.